set long 5000
select dbms_metadata.get_ddl('TABLE','EMP','SCOTT')
from dual;
Some other values of the type field for dbms_metadata.get_ddl function:
(See also “Oracle® Database PL/SQL Packages and Types Reference“)
MemoSoup
Mix of the things I always forget
