How to do view all the triggers in a schema?

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

Reply

The content of this field is kept private and will not be shown publicly.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.

Back to top