get oracle DDL

select DBMS_METADATA.GET_DDL('TABLE','USERS','ILPS') from dual;
select DBMS_METADATA.GET_DDL('TABLESPACE','SYSTEM') from dual;

dbms_metadata.GET_DDL

dbms_metadata.GET_DDL('PROCEDURE',u.object_name)


select
dbms_metadata.GET_DDL('PROCEDURE',u.object_name)
from
user_objects u
where
object_type = 'PROCEDURE';