Re: how to display a trigger programatically

From: Thomas Kellerer <FJIFALSDGVAF_at_spammotel.com>
Date: Sat, 15 Dec 2007 09:20:44 +0100
Message-ID: <5shh2sF191qq3U2@mid.individual.net>

Sean Nakasone wrote on 15.12.2007 02:31:
> Is there a way to display a trigger programatically, or via commandline,
> or via sql code? 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.

It's all stored in the dictionary views:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_2107.htm#sthref1739 Received on Sat Dec 15 2007 - 02:20:44 CST