VIEW: SYS.USER_INTERNAL_TRIGGERS

Source

View Text - Preformatted

select o.name, 'DEFERRED RPC QUEUE'
from sys.tab$ t, sys.obj$ o
where o.owner# = userenv('SCHEMAID')
      and t.obj# = o.obj#
      and bitand(t.trigflag,1) = 1
union
select o.name, 'MVIEW LOG'
from sys.tab$ t, sys.obj$ o
where o.owner# = userenv('SCHEMAID')
      and t.obj# = o.obj#
      and bitand(t.trigflag,2) = 2
union
select o.name, 'UPDATABLE MVIEW LOG'
from sys.tab$ t, sys.obj$ o
where o.owner# = userenv('SCHEMAID')
       and t.obj# = o.obj#
       and bitand(t.trigflag,4) = 4
union
select o.name, 'CONTEXT'
from sys.tab$ t, sys.obj$ o
where o.owner# = userenv('SCHEMAID')
      and t.obj# = o.obj#
      and bitand(t.trigflag,8) = 8

View Text - HTML Formatted

SELECT O.NAME
, 'DEFERRED RPC QUEUE' FROM SYS.TAB$ T
, SYS.OBJ$ O WHERE O.OWNER# = USERENV('SCHEMAID')
AND T.OBJ# = O.OBJ#
AND BITAND(T.TRIGFLAG
, 1) = 1 UNION SELECT O.NAME
, 'MVIEW LOG' FROM SYS.TAB$ T
, SYS.OBJ$ O WHERE O.OWNER# = USERENV('SCHEMAID')
AND T.OBJ# = O.OBJ#
AND BITAND(T.TRIGFLAG
, 2) = 2 UNION SELECT O.NAME
, 'UPDATABLE MVIEW LOG' FROM SYS.TAB$ T
, SYS.OBJ$ O WHERE O.OWNER# = USERENV('SCHEMAID')
AND T.OBJ# = O.OBJ#
AND BITAND(T.TRIGFLAG
, 4) = 4 UNION SELECT O.NAME
, 'CONTEXT' FROM SYS.TAB$ T
, SYS.OBJ$ O WHERE O.OWNER# = USERENV('SCHEMAID')
AND T.OBJ# = O.OBJ#
AND BITAND(T.TRIGFLAG
, 8) = 8