-- This script will create a SQL script to create any triggers in the current schema.
-- Mark Reineck 12-22-1997

set feedback off
set head off
set echo off
set recsep off
set pages 50000
set long 5000
set lines 200
column trigger_body format a200

-- Write the script to a file, otherwise it is useless

spool mktriggr.sql

-- Write the SQL stastements to rebuild the triggers

select 'create or replace trigger ' || description, trigger_body,'/'
from user_triggers; spool off;

-- Reset some stuff

set feedback on
set head on
set echo on