Wednesday, 23 November 2016

Oracle : Get source code of package

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;

No comments:

Post a Comment