METADATA GET DDL
SELECT DBMS_METADATA.GET_DDL ('TABLE', TABLE_NAME, OWNER)
FROM ALL_TABLES
WHERE OWNER = '<SCHMEA>'
AND TABLE_NAME = '<OBJECT>';
SELECT DBMS_METADATA.GET_DDL ('TABLE', TABLE_NAME, OWNER)
FROM ALL_TABLES
WHERE OWNER = '<SCHMEA>'
AND TABLE_NAME = '<OBJECT>';