Technical Blog

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

Step 1: SELECT 1  FROM DUAL WHERE EXISTS (SELECT 1 FROM  scott.experiment_lt   WHERE VERSION IN (SELECT VERSION FROM wmsys.wm$version_hie...