Tuesday, May 26, 2009

Extracting Oracle DDL Statements


select
dbms_metadata.get_ddl('TABLE','C_FEATURE','QA')
From dual;


parameters are
object type, object name, owner schema name