Extract Oracle Object DDL

set long 5000
select dbms_metadata.get_ddl('OJBECT_TYPE','OBJECT_NAME','OWNER') from dual;