From: Chris Hulan <chris.hulan@...>
Date: 2007-12-15T10:55:04+09:00
Subject: Re: how to display an oracle trigger programatically

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/mktrig.txt

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

cheers