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


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 Wed Jan 17 1996 - 00:00:00 CET

Original text of this message