How to Export Package in Oracle Database:
SET HEADING OFF
SET ECHO OFF
SET FLUSH OFF
SET LINES 200 PAGES 50000
SET LONG 99999999
SPOOL PACKAGE_NAME.pks
SELECT DBMS_METADATA.GET_DDL('PACKAGE','<PACKAGE_NAME>','<OWNER>') FROM DUAL;
SPOOL OFF;
SET ECHO OFF
SET FLUSH OFF
SET LINES 200 PAGES 50000
SET LONG 99999999
SPOOL PACKAGE_NAME.pks
SELECT DBMS_METADATA.GET_DDL('PACKAGE','<PACKAGE_NAME>','<OWNER>') FROM DUAL;
SPOOL OFF;
How to Export Package Body in Oracle Database:
SET HEADING OFF
SET ECHO OFF
SET FLUSH OFF
SET LINES 200 PAGES 50000
SET LONG 99999999
SPOOL PACKAGE_BODY_NAME.pkg
SELECT DBMS_METADATA.GET_DDL('PACKAGE','<PACKAGE_BODY_NAME>','<OWNER>') FROM DUAL;
SPOOL OFF;
