DBA Data[Home] [Help]

VIEW: SYS.USER_TRIGGER_ORDERING

Source

View Text - Preformatted

select trigger_name, referenced_trigger_owner,
  referenced_trigger_name, ordering_type
from sys."_DBA_TRIGGER_ORDERING"
where trigger_owner# = userenv('SCHEMAID')
View Text - HTML Formatted

SELECT TRIGGER_NAME
, REFERENCED_TRIGGER_OWNER
, REFERENCED_TRIGGER_NAME
, ORDERING_TYPE FROM SYS."_DBA_TRIGGER_ORDERING" WHERE TRIGGER_OWNER# = USERENV('SCHEMAID')