Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

SELECT JOB,WHAT,LAST_SEC,INTERVAL from USER_JOBS

SQL> -- SQL> SELECT JOB,WHAT,LAST_SEC,INTERVAL from USER_JOBS;        JOB ---------- WHAT -------------------------------------------------- LAST_SEC -------- INTERVAL --------------------------------------------------         21 HELLO; 18:12:52 SYSDATE + (1/(24*60*60))         22 HELLO; 18:12:52 SYSDATE + (1/(24*60*60))         41 HELLO; SYSDATE + (1/(24*60*60))         42 HELLO; SYSDATE + (1/(24*60*60)) 4 rows selected. SQL> SQL> --