Top "Plsqldeveloper" questions

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.

LISTAGG function with two columns

I have one table like this (report) -------------------------------------------------- | user_id | Department | Position | Record_id | -------------------------------------------------- | 1 | Science | Professor | 1001 | | 1 | Maths | | 1002 | | 1 | History | Teacher | 1003 | | 2 | …

oracle plsql oracle11g plsqldeveloper
pragma autonomous_transaction in a trigger

I have written a trigger on one table which deletes data from other table upon a condition. The trigger has …

oracle plsql triggers oracle11g plsqldeveloper
How to check the timezone of oracle pl/sql developer

Where do I check the timezone of oracle pl/sql developer.Can someone help please

sql oracle plsql plsqldeveloper
How to save passwords in PL/SQL Developer?

I've put my database info into Tnsnames.ora, and now each time I start PL/SQL Developer I get a …

plsqldeveloper
PL/SQL Developer Initialization error

I want use PL/SQL Developer first my oracle directory C:\oracle\product\10.2.0\client_1\BIN I use windows10 and environment …

oracle plsqldeveloper
Timezone conversion in PLSQL

I need to convert the sysdate and time to a particular timezone like EST. I can't assume my current time …

sql oracle plsql plsqldeveloper
PL/SQL Developer: Multiple statements?

I have a script that generates a text file containing several SQL UPDATE statements: UPDATE TableX SET Field1 = 'New value 1…

sql oracle plsqldeveloper
PL/SQL developer import dump

I have a dump file which includes two tables. Now I need to import this dump file. I was instructed …

oracle dump plsqldeveloper tablespace
Themes or Look and feel on PL/SQL Developer

How to change the look and feel or the colors of all in PL/SQL Developer? Because for current time, …

plsqldeveloper
How do I get line numbers in PL/SQL Developer?

In Preferences | User Interface | Editor | Other, I checked Display Line Numbers and set Interval to All. However, I still have …

user-interface plsqldeveloper