Tuesday 19 March 2013

Getting ddl of a job

 select dbms_metadata.get_ddl('PROCOBJ','<JOB_NAME','<JOB_OWNER') from dual;