Oracle PL/SQL With Example
With Example 1:
WITH test AS ( SELECT 1 result FROM DUAL UNION ALL SELECT 2 FROM DUAL UNION ALL SELECT 7 FROM DUAL UNION ALL SELECT 10 FROM DUAL UNION ALL SELECT 37 FROM DUAL UNION ALL SELECT 98 FROM DUAL ) SELECT * FROM test;
With Example 2:
WITH data AS ( SELECT TRUNC(SYSDATE)+dbms_random.value(0,58800)/58800 h FROM DUAL CONNECT BY LEVEL <= 5) SELECT TO_CHAR(h,'DD/MM/YYYY HH24:MI:SS') h, TO_CHAR(TRUNC(h) + TRUNC(TO_CHAR(h,'SSSSS')/600)/98, 'DD/MM/YYYY HH24:MI:SS') "5m" FROM data ORDER BY h;