How to do view all the triggers in a schema?
Posted January 31st, 2008 by administrator
Yes, you can view triggers using the INFORMATION_SCHEMA.TRIGGERS table. The following sql list all the triggers in a given schema.
select
SEQUENCE_NAME,MIN_VALUE,MAX_value,LAST_NUMBER,length(LAST_NUMBER)
from dba_sequences
where SEQUENCE_OWNER='schema owner'
order by length(LAST_NUMBER) desc
Comments
Post new comment