select * from dba_jobs; //執(zhí)行完的調(diào)度任務(wù)
select * from dba_jobs_running; //正在執(zhí)行的調(diào)度任務(wù)
select * from user_jobs;//調(diào)度任務(wù)
select * from user_source where type = 'procedure';
select * from user_objects where object_type = 'procedure';
select text from user_source where type = 'procedure' and name = 'procedure_name'