Getting the difference between dates - Ask Tom - Oracle

For example: SQL> set serveroutput on. SQL> SQL> declare 2 a date; 3 b date; 4 begin 5 a := sysdate; 6 dbms_lock.sleep(10); -- sleep about 10 seconds give or ...

asktom.oracle.com