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
47
votes
6 answers

How to test an Oracle Stored Procedure with RefCursor return type?

I'm looking for a good explanation on how to test an Oracle stored procedure in SQL Developer or Embarcardero Rapid XE2. Thank you.
Ryan Fisch
  • 2,614
  • 5
  • 36
  • 57
44
votes
4 answers

Explicitly set column value to null SQL Developer

I am new to Oracle DB and I am using Oracle SQL Developer (Ver 3.0.02) to query the DB. I wanted to explicitly set one column to null? How do I do that in the SQL Developer GUI? Previously in MSSQL, clicking CTRL+0 will explicitly set the value to…
Mark Estrada
  • 9,013
  • 37
  • 119
  • 186
36
votes
6 answers

How to connect to remote Oracle DB with PL/SQL Developer?

I have a database "TEST", to which I connect at address 123.45.67.89:1521. How do I connect to it using PL/SQL Developer?
Mikhail Orlov
  • 2,789
  • 2
  • 28
  • 38
28
votes
4 answers

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 no line numbers in my text editor window.
user565869
28
votes
1 answer

LISTAGG function with two columns

I have one table like this (report) -------------------------------------------------- | user_id | Department | Position | Record_id | -------------------------------------------------- | 1 | Science | Professor | 1001 | | 1 …
Jaanna
  • 1,620
  • 9
  • 26
  • 46
27
votes
7 answers

Escape ampersand in PL/SQL Developer

I'm trying a simple INSERT statement against an Oracle database. One of the values is a VARCHAR2 field and the insert statement contains an ampersand. How do I do this? I've tried the following methods: Escape the & as \& with set escape on set…
Ray Booysen
  • 28,894
  • 13
  • 84
  • 111
20
votes
9 answers

Is there a keyboard shortcut for writing "SELECT * FROM" template?

Is there a way to generate a SELECT * FROM template in SQL editor by a certain keyboard shortcut in PL/SQL Developer or another similar tool ? It would be great to save the time needed to write this repetitive statement with such keyboard shortcut.
user2850769
  • 321
  • 1
  • 2
  • 5
20
votes
4 answers

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 dropdown list of my databases, but I have to type in the password every time. There is an option under Tools>Preferences to store passwords for multiple…
axiomx11
  • 700
  • 1
  • 8
  • 15
19
votes
2 answers

how to convert a string date to date format in oracle10g

My date value is stored as varchar2 and the value is 15/August/2009,4:30 PM, how to convert this to a proper date format like DD-MM-YYYY.
leelavinodh
  • 435
  • 1
  • 8
  • 15
19
votes
14 answers

Oracle Convert Seconds to Hours:Minutes:Seconds

I have a requirement to display user available time in Hours:Minutes:Seconds format from a given total number of seconds value. Appreciate if you know a ORACLE function to do the same. I'm using Oracle. Thank you for your time.
user1430989
  • 525
  • 2
  • 6
  • 15
18
votes
7 answers

PL/SQL Developer cannot find my tnsnames.ora file

I have an Oracle tnsnames.ora file from my previous workplace. I want to pick it up with my newly installed PL/SQL Developer on another computer. I have copied the file into ..ORACLE/product/11.2.0/client_32/NETWORK/ADMIN, but PL/SQL Developer…
MiamiBeach
  • 3,261
  • 6
  • 28
  • 54
18
votes
4 answers

PL/SQL developer with oracle 32-bit/64-bit client

I have Oracle 64-bit client installed to run with my weblogic application. I learnt that pl-sql developer doesn't work with oracle 64-bit client so now i have both 32-bit and 64-bit clients installed on my machine and my ORACLE_HOME variable points…
Adithya
  • 2,923
  • 5
  • 33
  • 47
16
votes
6 answers

How to parse comma delimited string in PL/SQL?

I have a comma delimited string in a PL/SQL script (e.g. data:= 'a,b,c,d,e'), that I need to parse out within the script. I would like to loop through the string and process each item. Like a 'foreach' loop. Is this possible in PL/SQL? Can someone…
TERACytE
  • 7,553
  • 13
  • 75
  • 111
15
votes
2 answers

How to make dbms_metadata.get_ddl more pretty/useful

I am creating a package to generate the DDL of objects in my schema (you parse the object name, and return a clob with DDL), so I can generate files, and put them straight into SVN. I am using dbms_metadata.get_ddl, and it works great for all…
Patryk Turowicz
  • 151
  • 1
  • 1
  • 6
15
votes
2 answers

If statement within Where clause

I am working with a query which contains "IF" statements within a "WHERE" clause. But PL\SQL Developer is giving some errors while executing it. Can anyone please help me with the correct query? Here is the query: SELECT t.first_name, …
user2100620
  • 311
  • 2
  • 5
  • 17
1
2 3
…
99 100