Extract Package in Oracle DB

Extract Package in Oracle DB

=========================================================================METHOD 1

=========================================================================

SET LINESIZE 29999;

SET TERM OFF;

SET PAGESIZE 100000;

SET LONG 10000000;

SPOOL TEST_PACKAGE.TXT;

SELECT dbms_metadata.get_ddl( 'PACKAGE', 'TEST_PACKAGE', 'ILTCIS') FROM dual;

SPOOL OFF;

===========================================================================

METHOD 2

===========================================================================

SET LINESIZE 29999;

SET TERM OFF;

SET PAGESIZE 999;

SPOOL TEST_PACKAGE_1.txt

select TEXT from user_source where name='TEST_PACKAGE' and type='PACKAGE BODY';

=========================================================================

တစ္ခါတစ္ေလ လိုအပ္တတ္ပါတယ္။ package ကူးထားခ်င္တဲ႔အခါမွာအသံုးဝင္ပါလိမ္႔မယ္။