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 read string from right PLSQL

In a table column, I have this value: DV-2011-01-000004 (the data type is varchar2) How can i get …

plsql plsqldeveloper
Query execution time in PL/SQL Developer

I'm running queries in PL/SQL Developer. How to find out the running time of sql query in PL/SQL. …

sql plsql plsqldeveloper
Why do I get an open transaction when just selecting from a database View?

If I execute a simple select statement in pl/sql developer against a database table, I get a standard set …

sql oracle plsql oracle11g plsqldeveloper
PL/SQL Associative array validate if index exist

I have this Associative array 3-d type v_arr_class is table of varchar2(255) index by varchar2(255); type v_arr_…

arrays plsql plsqldeveloper
Generate test data using Oracle PL/SQL developer

I want to test some schemas and indexes, and I was wondering if there is a functionality in PL/SQL …

database oracle plsql plsqldeveloper test-data
How can I test a function working or not in pl-sql?

I learned the basics of writing a function and procedure in pl-sql but I don't know how to test if …

oracle function debugging plsqldeveloper
When debugging a package procedure in PL/SQL developer, how do you set a CLOB in parameter value?

I'm debugging an Oracle package using PL/SQL developer, but I'm running into a problem - one of the parameters …

plsql plsqldeveloper
Error when trying to log in: ORA-12154

I am using Oracle 10g and PL/SQL Developer for the development. I have already tested from Net Manager that …

oracle plsqldeveloper ora-12154
Compare two SELECT statement using PL/SQL Developer

Suppose I have two SELECTquery on same table and I need to compare them column by column. Query 1: select * from …

sql oracle plsqldeveloper
How to print SYS_REFCURSOR with PLSQLDeveloper window?

In the below query how to get IO_CURSOR values in PL/SQL's "SQL Window" DECLARE SOME_VAR_1 VARCHAR2(20); SOME_…

oracle plsqldeveloper