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.

Sean Nakasone wrote:
SELECT dbms_metadata.get_ddl('TRIGGER', <trigger_name>) FROM dual;

Demos here:
http://www.psoug.org/reference/dbms_metadata.html
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Sean Nakasone wrote on 15.12.2007 02:31:
It's all stored in the dictionary views:

http://download.oracle.com/docs/cd/B...htm#sthref1739