Reconstruct trigger from source - How?
From: badri <badri_at_cc.gatech.edu>
Date: 1996/01/17
Message-ID: <4dkesu$1vh_at_gaia.cc.gatech.edu>#1/1
Date: 1996/01/17
Message-ID: <4dkesu$1vh_at_gaia.cc.gatech.edu>#1/1
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 thereany site where there are SQL scripts that I can download?
thanks a lot,
-Badri Received on Wed Jan 17 1996 - 00:00:00 CET