Technical Blog

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...

select table_name, num_rows, blocks, avg_row_len from dba_tables where table_name='EMP'; select table_name, monitoring from dba_...