DLL de una tabla.

SELECT DBMS_METADATA.get_ddl ('TABLE', table_name, owner)

FROM   all_tables
WHERE  owner      = UPPER('&1')
AND    table_name = DECODE(UPPER('&2'), 'ALL', table_name, UPPER('&2'));

SET PAGESIZE 14 LINESIZE 100 FEEDBACK ON VERIFY ON