Generate DDL commands of existing objects

With dbms_metadata it’s easy to generate DDL commands of existing objects.

TABLES

SET LONG 20000 PAGESIZE 0 HEADING off
select dbms_metadata.get_ddl('TABLE','EMP','SCOTT') from dual;

Advertisements