SELECT dbms_metadata.get_ddl('TABLE','EMP','SCOTT') FROM dual;Or, you can query for all of your tables using the Data Dictionary:
SELECT dbms_metadata.get_ddl('TABLE',table_name,USER) FROM user_tables;
Dig deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.