Re: all_triggers

dw wrote:
> Well that's what I did in the end. Granted select on DBA_TRIGGERS. I
> was merely exploring what the others do in a similar situation. Thanks
> for the input.
>
> You can always choose not to reply to a thread if its too trivial !!!!

Not trivial ... just confusing. Most people ask questions such as this when they don't know about ALL_TRIGGERS.

The solution I would have used was to create a custom view with just the columns and objects I needed based on the source code for ALL_TRIGGERS.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)