col what for a50
col last_date for a25
col this_date for a25
select /*+ rule */ b.what,a.* from dba_jobs_running a,dba_jobs b
where a.job=b.job;
col what for a50
col last_date for a25
col this_date for a25
select /*+ rule */ b.what,a.* from dba_jobs_running a,dba_jobs b
where a.job=b.job;