www.oracle-wiki.net SQL Library
-- -- Show the Number of Days Between Two Dates -- SET PAUSE ON SET PAUSE 'Press return to Continue' SET LINESIZE 300 SET PAGESIZE 60 SELECT ROUND ( (MONTHS_BETWEEN ('01-Jan-2000', '01-Jan-2010'), 0) FROM DUAL /