Question

How To Generate Ddl For A Table?

Answer 1

Answer:

Explanation:

select dbms_metadata.get_ddl('TABLE', 'YOUR_TABLE_NAME') from dual; You can also do this for all tables at once: select dbms_metadata.get_ddl('TABLE', table_name) from user_tables; and spool the output into a SQL script.