Santosh's Oracle DBA Blog
For Oracle DBA begineers
Pages
Home
Thursday, 7 March 2013
Get DDL command in oracle
Get DDL command from SQL query
select dbms_metadata.get_ddl('OBJECT_TYPE','OBJECT_NAME') FROM DUAL;
e.g:
select dbms_metadata.get_ddl('TABLE','WORK') FROM DUAL;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment