Wednesday, December 12, 2012

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