# How to display an oracle trigger programatically

**URL:** <https://www.ruby-forum.com/t/how-to-display-an-oracle-trigger-programatically/123225>\
**Category:** Ruby\
**Created:** [December 15, 2007, 2:46am UTC](https://www.ruby-forum.com/t/how-to-display-an-oracle-trigger-programatically/123225 "2007-12-15T02:46:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sean\_n](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/858c86/32.png) [@sean\_n](https://www.ruby-forum.com/u/sean_n)\
**Post date:** [December 15, 2007, 2:46am UTC](https://www.ruby-forum.com/t/how-to-display-an-oracle-trigger-programatically/123225/1 "2007-12-15T02:46:26Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![sean\_n](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/858c86/32.png) [@sean\_n](https://www.ruby-forum.com/u/sean_n)\
**Post date:** [December 15, 2007, 2:56am UTC](https://www.ruby-forum.com/t/how-to-display-an-oracle-trigger-programatically/123225/2 "2007-12-15T02:56:22Z")

</div>

On Dec 14, 8:39 pm, Sean N. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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](http://www.orafaq.com/scripts/sql/mktrig.txt)

Don’t really need Ruby, but it’d be easy to adapt…

cheers