Find a column and a value from a schema scan all the table in oracle...

WHILE & FOR LOOP...

can we use default in a variable with function call in plsql?...

Nested decode in where clause...

How to output different values in a single record...

How do I find the last DDL of a procedure which is inside an ORACLE package?...

I tried to fetch bulkcollect records from sys_refcursor and tried to insert another table using fora...

Error: Cant create procedure with select in PL/SQL...

ORA-00600: internal error code when compiling function returning Pipelined...

What is the difference between a "procedure name IS' and a "Procedure name AS" in...

PLSQL Exception handling in GET_FILE...

how to use dbms_lob.substr in sql*plus...

C# with plsql in Visual Studio 2010...

i have a issue in body package pl/sql when I select...

How can I call a procedure in a different package in a different schema from another...

Can we call a private procedure of a package from another package and can we call database procedure...

Overloading problem: Error(83,5): PLS-00307: too many declarations of 'REPORTEQ' match this ...

How to compile Oracle package with APEX functions?...

What does it means when there are two functions with the same name but different parameter in the pa...

Passing Variable in Sum Function in PLSQL...

How to access just one OUT value from a Procedure that returns multiple OUT values?...

Many to Many Relationship table Not working cannot delete Value from that...

find string with quotes and double quotes in all oracle packages...

What is wrong in the program?...

How to loop G_FXX where XX = (01,02..n) in Oracle Apex?...

PL/SQL Functions in collection type...

Optional condition in Oracle 10g...

Error on sysdate and does not compile...

select inside a case statement not works...

Oracle PLSQL : How to use substitution variable based on each value?...