Tuesday 22 November 2016

TO take procedure backup from Sqlplus

REM procedure, package or package body.
REM This SCRIPT is provided as a guide and is not supported by
REM ORACLE Corporation.
set verify off
set feedback off
set lines 132
set pages 0
set heading off
set space 0
column text format a79
column line noprint
select DECODE(line,1,'create or replace ','')||text, line
from dba_source
where
owner = upper('APPS') and
type = upper('PACKAGE BODY')
and name = upper('XXLR_INTF_BOS_JDE_WO_PKG')
and line >= 1;
set verify on
set feedback on

No comments:

Post a Comment