Pages

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