How to display an oracle trigger programatically

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

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs