SR 4 DB

--- Format set heading off; set echo off; Set pages 999 ; set long 90000 ; BEGIN dbms_metadata.set_transform_param ( DBMS_METADATA.SESSION_TRANSFORM , 'PRETTY' , TRUE ); dbms_metadata.set_transform_param ( DBMS_METADATA.SESSION_TRANSFORM , 'SQLTERMINATOR' , TRUE ); END; / --- Example   select dbms_metadata.get_ddl ( 'TRIGGER' , '&TRIGGER_NAME , '&OWNER' ) from dual ; select dbms_metadata.get_ddl ( 'TYPE' , '&TYPE_NAME' , '&OWNER' ) from dual ; select dbms_metadata.get_ddl ( 'INDEX' , '&INDEX_NAME' , '&OWNER' ) from dual ; select dbms_metadata.get_ddl ( 'TABLE' , '&TABLE_NAME' , '&OWNER' ) from dual ; select dbms_metadata.get_ddl ( 'TABLESPACE' , '&TABLESPACE_NAME' ) from dual ; select dbms_metadata.get_ddl ( 'PROCEDURE' , '&PROCE

---***************************** ---* Compile objets * ---* By Pablo Vivas. Vzla * ---* By Eini Trujillo. Vzla * ---* July 2014 * ---***************************** set lin 80 set pages 101 SELECT CASE object_type WHEN 'PACKAGE BODY' THEN 'ALTER PACKAGE ' || owner || '.' || object_name || ' COMPILE BODY;' WHEN 'VIEW' THEN 'ALTER VIEW ' || owner || '.' || object_name || ' COMPILE;' WHEN 'PROCEDURE' THEN 'ALTER PROCEDURE ' || owner || '.' || object_name || ' COMPILE;' WHEN 'TRIGGER' THEN 'ALTER TRIGGER ' || owner || '.' || object_name || ' COMPILE;' WHEN 'FUNCTION' THEN 'ALTER FUNCTION ' || owner || '.' || object_name || ' COMPILE;' WHEN 'SYNONYM' THEN (SELECT '