Oracle Get DDL for an object

From WickyWiki
Revision as of 07:26, 5 July 2013 by Admin (talk | contribs) (6 revisions)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

The result will be a create-table statement:

SELECT DBMS_METADATA.GET_DDL('TABLE','USER1.TABLE1') from dual;