SET LONG 1000000
UNDEFINE trigger_name
SET PAGES 0
SET FEEDBACK OFF
SET LINES 132
set echo off
set numwidth 9
Set head off
set verify off
set time off
set timing off
COLUMN text FORMAT A302 word_wrapped
COLUMN spool_name NEW_VALUE spool_name NOPRINT
SELECT lower(trigger_name||’.ctr’) spool_name
FROM dba_triggers
WHERE trigger_NAME = UPPER(‘&&trigger_name’);
SPOOL &spool_name
select ‘CREATE OR REPLACE TRIGGER ‘
||DESCRIPTION
from dba_triggers
where trigger_NAME = UPPER(‘&&trigger_name’);
set lines 95
SELECT trigger_body text
FROM DBA_TRIGGERS
WHERE TRIGGER_NAME = UPPER(‘&&trigger_name’);
PROMPT /
SPOOL OFF
SET PAGES 80
SET FEEDBACK 1
set LINES 132
set echo on
Set head on
set feedback 1
set verify on
set time on
set timing on