comp.lang.ruby

Chris Hulan

12/15/2007 1:50:00 AM

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.

Here is a SQL script that extracts trgger code:
http://www.orafaq.com/scripts/sql/...

Don't really need Ruby, but it'd be easy to adapt...

cheers