Stack Overflow
Stack Overflow

Questions tagged [plsqldeveloper]

PL/SQL Developer is an Integrated Development Environment by Allround Automations that is specifically targeted at the development of stored program units for Oracle Databases.

PL/SQL Developer is an Integrated Development Environment by Allround Automations that is specifically targeted at the development of stored program units for Oracle Databases.

Home page: http://www.allroundautomations.com/plsqldev.html

PL/SQL Developer should not be confused with Oracle's SQL Developer: http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html

1591 questions
1
vote
2 answers

Writing a SQL query over a given set of values

I am trying to write a plsql query that allows me to query a set of known values that are not stored in a table. Say those known values are the following strings: abc def ghi jkl I would like to achieve something like the following: select *…
Gavin Osborn
  • 2,593
  • 3
  • 27
  • 42
1
vote
2 answers

How to select a matrix of distinct values in PL/SQL using “where” expression for each cell

I’m interested to analyze a table in Oracle which has the following form: Column A Column B Column C 11 0 A 14 1 7 45 3 3 64 3 3 80 7 3 IMPORTANT: Column A is varchar2(10) Column B is Number(1) Column C is Char(1) A is primary…
Logy Tegus
  • 13
  • 3
1
vote
1 answer

How to handle if value comes with 0 and multiple dynamically in oracle sql?

#following 5001 (param s_id) is dynamically called. this was not worked and not return any rows from student table. what is the root cause for this issue?# select * from student where ( ( 1 = CASE WHEN to_char('5001') = to_char(0) THEN …
DIPAK SHAH
  • 33
  • 1
  • 8
1
vote
1 answer

PL SQL: group by, drop NULL, drop duplicates, save to list

I need to do something like: def first_items(x: pd.Series): """Helper function for items those aren't NA.""" arr = x.values arr = np.unique(arr[~pd.isna(arr)]) if not len(arr): return np.nan elif len(arr) == 1: …
Любовь Пономарева
  • 314
  • 1
  • 2
  • 9
1
vote
1 answer

Query to Print this Data pattern in Pl/SQL

How can I print data in this pattern in Pl/SQL 1~ABC~20-June-1990^2~DEF~03-Aug-1999^3~IJK~19-DEC-1976^.... Here this 1, ABC, 20-June-1990 likewise other 2, DEF, 03-Aug-1999 stored in table. I have to fetch this data and print in the above format in…
Amritesh Asthana
  • 15
  • 3
1
vote
1 answer

PLSQL Returning Multiple Lines From user_source

some_expression; another_expression; raise_application_error(-20100 , 'Explanation message.'); expression; The column has the text above. The text contains raise_application_error function call in more than one lines. I want…
mertcan
  • 45
  • 5
1
vote
1 answer

PL/SQL data type support for size greater than NVarchar2

PL/SQL has data type NVARCHAR2(size) where the size is 32767 bytes; equivalent to 4095 records. Now, what data type should i give as an alternative to NVARCHAR2 that could support more than 4k records? I have a gridview in asp.net that doesn't…
xorpower
  • 17,975
  • 51
  • 129
  • 180
1
vote
2 answers

Is there some way to automatically export the query results in PL/SQL Developer? CSV or XLSX for example

I've tried some codes like these below: select /*csv*/ * from users; , spool "C:/Users/Douglas/Desktop"; select /*csv*/ * from users; spool off; AND --CSV=C:\Users\dvferreira\Desktop\temp.csv select * from users; Is there anything else I can…
Douglas Vicentini
  • 132
  • 2
  • 11
1
vote
0 answers

Failed to execute policy function in Oracle. Function in policy has error when i assign variable by "Select into"

If was ok when i create a function and add a policy in Oracle. Error happen when i want to select a table (OBJECT_NAME). It seems like error happen in the select into variable, but i dont know how to fix it (I make sure that select into 1 variable…
Văn Đình Khôi
  • 13
  • 3
1
vote
1 answer

ORA-01017 Invalid Username/Password logon denied when connecting to 19C database

I'm trying to connect to a schema on 19C local database. Ibefore it works very well but today I found this error ORA-01017: invalid username/password; logon denied . The username and password are DEFINITELY correct - can anyone think of a reason why…
Ora_en
  • 25
  • 1
  • 7
1
vote
1 answer

Different results when using a CURSOR and direct SQL execute? - PL/SQL

While debugging, I came across a strange situation today with a query that has a join condition on a column that could be NULL. I have data in two tables like this: emp_payment_trans_tab: emp_payment_tab: When I execute this statement, I get no…
Uthpala Dl
  • 45
  • 8
1
vote
1 answer

How can I see output of dbms_output.put_line() in SQL window in PL/SQL Developer?

I'm not able to see the messages added to dbms_output.put_line() in PL/SQL Developer. Every google hit I see says to use set serveroutput on but this isn't working. I try to run this script in a SQL Window: set serveroutput on; BEGIN …
gib65
  • 1,709
  • 3
  • 24
  • 58
1
vote
0 answers

How to extract plsql query columns name, tables name, functions name and it's parameters name in java

I am trying a functions which can extract the columns name,which may have alias names also, tables name, if inner queries are added it should get those columns also and if function are used in query it should get functions parameters and function…
AyushKaran
  • 11
  • 1
  • 5
1
vote
1 answer

Retrieve data by user input with a message (PL/SQL)

I want to how to retrieve data from the table I have added here by inserting C_Id as the user input with defined variables and exceptions. If any customer is not available it has to display a message showing "No customer found". Please help me to…
tuneKawaii UwU
  • 73
  • 1
  • 7
1
vote
1 answer

Copy path to opened file in PL SQL developer

When I open files in PL SQL developer I want to copy file path so I can go directly to the directory I need. One way is to hover on the file and wait for tool tip to appear. But I have to wait a few seconds and I am not able to copy the path. Can I…
vytaute
  • 1,260
  • 4
  • 16
  • 36
1 2 3
…
99 100