Quickly get source code : Use last select for more generic output.
select dbms_metadata.get_ddl('PACKAGE','&PACK','&SCHEMA') from dual;
select dbms_metadata.get_ddl('PACKAGE_BODY','&PACK','&SCHEMA') from dual;
or
Select TEXT from SYS.DBA_SOURCE where NAME='&PACK' and TYPE='PACKAGE' order by LINE;
Select TEXT from SYS.DBA_SOURCE where NAME='&PACK' and TYPE='PACKAGE BODY' order by LINE;
or
Select TEXT from SYS.DBA_SOURCE where NAME='&PACK' order by LINE;
select dbms_metadata.get_ddl('PACKAGE','&PACK','&SCHEMA') from dual;
select dbms_metadata.get_ddl('PACKAGE_BODY','&PACK','&SCHEMA') from dual;
or
Select TEXT from SYS.DBA_SOURCE where NAME='&PACK' and TYPE='PACKAGE' order by LINE;
Select TEXT from SYS.DBA_SOURCE where NAME='&PACK' and TYPE='PACKAGE BODY' order by LINE;
or
Select TEXT from SYS.DBA_SOURCE where NAME='&PACK' order by LINE;
No comments:
Post a Comment