Otros objetos en un esquema Oracle

Sirve para obtener el ddl de tablas, vistas y procedimientos.

select DBMS_METADATA.GET_DDL('PROCEDURE' ,OBJECT_NAME)  from SYS.ALL_OBJECTS where upper(OBJECT_TYPE) = upper('PROCEDURE')
AND OWNER='nombre_esquema'
order by OWNER, OBJECT_NAME

select DBMS_METADATA.GET_DDL('TABLE' ,OBJECT_NAME)  from SYS.ALL_OBJECTS where upper(OBJECT_TYPE) = upper('TABLE')
AND OWNER='nombre_esquema'
 order by OWNER, OBJECT_NAME 
 
select DBMS_METADATA.GET_DDL('VIEW' ,OBJECT_NAME)  from SYS.ALL_OBJECTS where upper(OBJECT_TYPE) = upper('VIEW')
AND OWNER='nombre_esquema'
 order by OWNER, OBJECT_NAME