Oracle Get DDL for an object

From WickyWiki

The result will be a create-table statement:

SELECT DBMS_METADATA.GET_DDL('TABLE','USER1.TABLE1') from dual;