Dba Triggers

Description: Returns Trigger details.

SET linesize 132;
col trigger_name format a20;
col when_clause format a40;
SET LONG 132;
break ON trigger_name;
SELECT trigger_name,trigger_type,triggering_event,table_name,when_clause,trigger_body
FROM sys.dba_triggers
WHERE owner = UPPER('&1');

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.