Get the DDL for a Given Table 
--
-- Get the DDL for a Given Table
--
 
SELECT DBMS_METADATA.get_ddl ('TABLE', '&table_name', '&schema_name') FROM DUAL
/

Published 1st January 2022

createdbms_ddlget_ddlmetadata
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License