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
···
On Dec 14, 8:39 pm, Sean Nakasone <seannakas...@yahoo.com> 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.