2009-01-31

How to get the DDL of an Oracle table

This is just one of many ways you can get a the DDL of a table in Oracle:
select dbms_metadata.get_ddl('TABLE', 'YOUR_TABLE'.'YOUR_SCHEMA') from dual;