Is there a way to display an Oracle trigger programatically? The only
way
I know how to display a trigger is to use toad’s gui, but i want to loop
through all triggers and dump trigger contents to a file using a batch
procedure. Ideally I’d like to use a ruby script with the oracle dbi
module.
On Dec 14, 8:39 pm, Sean N. [email protected] wrote:
Is there a way to display an Oracle trigger programatically? The only way
I know how to display a trigger is to use toad’s gui, but i want to loop
through all triggers and dump trigger contents to a file using a batch
procedure. Ideally I’d like to use a ruby script with the oracle dbi
module.
Here is a SQL script that extracts trgger code:
http://www.orafaq.com/scripts/sql/mktrig.txt
Don’t really need Ruby, but it’d be easy to adapt…
cheers