How to Get DDL for Function and Packages Body in oracle Database.

How to Get DDL for Function and  Packages Body in oracle Database.


SET LONG 200000000 LONGCHUNKSIZE 2000000 PAGESIZE 0 LINESIZE 10000000000 FEEDBACK OFF
spool nil1w4.sql
select dbms_metadata.get_ddl('FUNCTION','CCSAR','ERP') from dual;

SET LONG 20000

set pagesiz 180

select replace(dbms_metadata.get_ddl ('PACKAGE_BODY', 'GEN_EXT', 'nil_APP'),' ','') from dual;

set heading off

set echo off

set flush off

--set pagesize 8000

set pagesize 0

set linesize 80

--set linesize 980

--set long 3999

set long 99999

set longc 3999

spool Code_chkpb.sql

select replace(dbms_metadata.get_ddl ('PACKAGE_BODY', 'GEN_EXT', 'nilesh_APP'),' ',' ') from dual;

To Compile package.

ALTER PACKAGE BODY VT.JOHN COMPILE;   

To Drop a Package,function  in the Database.

Drop PACKAGE VTXUSR_APP.GEN_SALES_TAX_EXTRACT;

DROP FUNCTION  erp."nil";