Re: how to display a trigger programatically

Sean Nakasone wrote:
> 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.

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_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org