The script is useful to list the triggers for a given table.

 

 

DEFINE TAB = &TABLENAME

prompt Triggers on TAB

column trigger_name format a40
column trigger_type format a40
column triggering_event format a20
set linesize
500

select trigger_name ,
       trigger_type ,
       triggering_event
from all_triggers where table_name = UPPER(
'&&TAB')
/
UNDEFINE TABLENAME
set linesize
100

Hosted by www.Geocities.ws

1