VIEW: SYS.KU$_10_2_TRIGGER_VIEW

Source

View Text - Preformatted

select * from ku$_11_2_trigger_view t
    /* 8192 = crossedition, 16384 = follows, 32768 = precedes, 65536 = forward
       131072 = reverse */
    where bitand(t.property, 8192+16384+32768+65536+131072) = 0
    and t.type_num != 5                                  /* compound trigger */

View Text - HTML Formatted

SELECT *
FROM KU$_11_2_TRIGGER_VIEW T /* 8192 = CROSSEDITION
, 16384 = FOLLOWS
, 32768 = PRECEDES
, 65536 = FORWARD 131072 = REVERSE */
WHERE BITAND(T.PROPERTY
, 8192+16384+32768+65536+131072) = 0
AND T.TYPE_NUM != 5 /* COMPOUND TRIGGER */