Technical Blog

Oracle Database provides the flexibility to leverage programming language functionality within the database without having to write comple...

Improving Performance of Dynamic SQL with Bind Variables When you code INSERT, UPDATE, DELETE, and SELECT statements directly in PL/SQL,...

Query to convert comma separated values into rows   with test as (select '1,2,3' col1 from dual) select regexp_substr(col1, ...

In the FOR IN clause of PIVOT keyword, we cannot use column names , can only use values  ORA-56901 : non -constant expression is not al...

Part 1 ---------------------------------------------------------------------------------------------------   Inband: Retrieve t...