SELECT JOB,WHAT,LAST_SEC,INTERVAL from USER_JOBS : USER_JOBS « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. USER_JOBS

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

 

Related examples in the same category