get table, index, constraint ddl

TABLE:

select dbms_metadata.get_ddl(‘TABLE’,’table_name’,’schema’) from dual;

 

INDEX:

select dbms_metadata.get_ddl(‘INDEX’,’index_name’,’schema’) from dual;

 

CONSTRAINT:

select dbms_metadata.get_ddl(‘CONSTRAINT’,’table_name’,’schema’) from dual;

Advertisements