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.

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 …

oracle stored-procedures plsqldeveloper ref-cursor rapidsql
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 …

database oracle plsqldeveloper authentication
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 …

oracle oracle10g plsqldeveloper
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 …

oracle null oracle11g oracle-sqldeveloper plsqldeveloper
Oracle 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 …

plsqldeveloper tnsnames
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 …

sql oracle plsql plsqldeveloper
How to create a dump with Oracle PL/SQL Developer?

I need to take dump of a user (including tables, procedures ,etc.) as FILENAME.dmp. If I create a new …

oracle plsqldeveloper
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 …

oracle plsql plsqldeveloper
ORA-12154: TNS:could not resolve the connect identifier specified (PLSQL Developer)

I need to use PLSQL Developer to access oracle databases. I get the following error when I try to connect …

oracle plsql sqlplus plsqldeveloper tnsnames
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 …

plsqldeveloper oracleclient