how to display an oracle trigger programatically

[Sean Nakasone]

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.

 

[Chris Hulan]

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