Re: Reconstruct trigger from source - How?

Badri,

You can try the following:

set pagesize 999 pause off heading off
set long 5000 -- Experement with this for your trigger body. select 'create or replace trigger '||trigger_name,

        trigger_body
  from dba_triggers
 where trigger_name = '<your trigger name(in caps)>';

Vikram Goel

Sr. DBA

Aerotek Inc.

Florida

reply to : vgoel_at_emi.net

In article <4dkesu$1vh_at_gaia.cc.gatech.edu>, badri_at_cc.gatech.edu (badri) writes:
>Hi:
>
> Can anyone out there post a script to spool the trigger
>creation script from the way it is stored in user_triggers or any
>other table? I tried, but the long format gets me all the time and
>I end up getting a messy output.
>
> In other words, I want the output to look as follows:
>
> Create trigger trig_name
> Before....
> END;
> /
>
> from the way it is stored in the database tables. Is there
>any site where there are SQL scripts that I can download?
>
>thanks a lot,
>
>-Badri
Received on Thu Jan 18 1996 - 00:00:00 CET