Doc

     Name:    triggers.sql

     Author:  Mark Gurry

     This script lists all triggers with their current
     status. Triggers can have a marked effect on 
     performance, so it is critical that you are aware
     of their existence.

#

ttitle 'Triggers and Their Status'

ttitle 'List All Triggers'
select table_name, trigger_name, status
	from all_triggers
 order by table_name, trigger_name;