Get DDL of a scheduler job
syntax - > select dbms_metadata.get_ddl('PROCOBJ','JOB_NAME','JOB_OWNER') from dual;
oracle configurationintermediate
by OracleDba
13 views
📋Steps in this guide1/1
1
Get DDL of a scheduler job
syntax
- > select dbms_metadata.get_ddl('PROCOBJ','JOB_NAME','JOB_OWNER') from dual;
Code/Command (click line numbers to comment):
1
select dbms_metadata.get_ddl('PROCOBJ','DUP_ACC','SCOTT') from dual;Comments (0)
Please to add comments
No comments yet. Be the first to comment!