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 ကူးထားခ်င္တဲ႔အခါမွာအသံုးဝင္ပါလိမ္႔မယ္။
