Export Data Definition Script from an Oracle Database

Question

I am new at working with oracle, my only experience is in sql server. In SQL server you can right click a table and say export create script. I need that for Oracle, specifically 10g. Is there a way via GUI or sql command that can accomplish this?

Answer 1

Calling dbms_metadata.get_ddl is one option.

e.g.

SET LONG 10000 

SELECT dbms_metadata.get_ddl('TABLE', 'MY-TABLE-NAME')
FROM dual;

Alternatively a number of GUI tools including TOAD and Enterprise Manager have DDL generators.