Join dba_jobs_running and dba_jobs : dba_jobs_running « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. dba_jobs_running

SQL>
SQL>
SQL> SELECT a.job, what,
  2         TO_CHAR(SYSDATE, 'mm/dd/yyyy hh24:mi:ss') now,
  3         TO_CHAR(a.this_date, 'mm/dd/yyyy hh24:mi:ss') this
  4  FROM   dba_jobs_running a, dba_jobs b
  5  WHERE  a.job = b.job and rownum < 50;

no rows selected

SQL>