VIEW: SYS.KU$_TRIGGER_VIEW

Source

View Text - Preformatted

select '1','4',
         t.obj#, value(o), t.baseobject,
         (select u.name from user$ u
          where u.user#=t.baseobject
            and bitand(t.property,16)!=0),
         (select value(bo) from ku$_schemaobj_view bo
          where t.baseobject = bo.obj_num
            and bitand(t.property,8+16)=0),
         (select trunc(tb.property/power(2,32)) from sys.tab$ tb
          where tb.obj#=t.baseobject),
         (SELECT unique 1 FROM sys.rls$ r,  ku$_schemaobj_view bo
          WHERE t.baseobject = bo.obj_num and bo.TYPE_NAME='TABLE' AND
              r.obj# = t.baseobject and
              r.PFSCHMA = 'XDB' AND
              r.PPNAME='DBMS_XDBZ0' AND
              (o.NAME like '%$xd' or
               o.NAME like '%$dl')),
         t.type#, t.update$, t.insert$, t.delete$,
         t.refoldname, t.refnewname,
         sys.dbms_metadata_util.is_schemaname_exists(t.definition),
         -- bug 4352110: strip nulls from definition, whenclause
         replace(t.definition,chr(0)),
         sys.dbms_metadata_util.parse_trigger_definition(o.owner_name,o.name,
                                         replace(t.definition,chr(0))),
         replace(t.whenclause,chr(0)),
         sys.dbms_metadata_util.long2clob(t.actionsize,
                                        'SYS.TRIGGER$',
                                        'ACTION#',
                                        t.rowid),
         NULL,
         t.actionsize,
         t.enabled, t.property, t.sys_evts,
         t.nttrigcol, t.nttrigatt,
         (select ntcol.name from sys.viewtrcol$ ntcol
          where bitand(t.property, 63)>= 32 and t.baseobject = ntcol.obj#
          and t.nttrigcol = ntcol.intcol# and t.nttrigatt = ntcol.attribute#),
         t.refprtname, t.actionlineno,
         cast(multiset(select * from ku$_triggercol_view tv
                        where tv.obj_num=t.obj#
                      ) as ku$_triggercol_list_t
             ),
         cast(multiset(select * from ku$_triggerdep_view td
                        where td.obj_num=t.obj#
                      ) as ku$_triggerdep_list_t
             ),
         (select value(c) from ku$_switch_compiler_view c
                 where c.obj_num =o.obj_num)
 from   sys.ku$_edition_schemaobj_view o, sys.trigger$ t
  where  t.obj# = o.obj_num AND
         (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner_num, 0) OR
                EXISTS ( SELECT * FROM sys.session_roles
                        WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '4'
, T.OBJ#
, VALUE(O)
, T.BASEOBJECT
, (SELECT U.NAME
FROM USER$ U
WHERE U.USER#=T.BASEOBJECT
AND BITAND(T.PROPERTY
, 16)!=0)
, (SELECT VALUE(BO)
FROM KU$_SCHEMAOBJ_VIEW BO
WHERE T.BASEOBJECT = BO.OBJ_NUM
AND BITAND(T.PROPERTY
, 8+16)=0)
, (SELECT TRUNC(TB.PROPERTY/POWER(2
, 32))
FROM SYS.TAB$ TB
WHERE TB.OBJ#=T.BASEOBJECT)
, (SELECT UNIQUE 1
FROM SYS.RLS$ R
, KU$_SCHEMAOBJ_VIEW BO
WHERE T.BASEOBJECT = BO.OBJ_NUM
AND BO.TYPE_NAME='TABLE' AND R.OBJ# = T.BASEOBJECT AND R.PFSCHMA = 'XDB' AND R.PPNAME='DBMS_XDBZ0' AND (O.NAME LIKE '%$XD' OR O.NAME LIKE '%$DL'))
, T.TYPE#
, T.UPDATE$
, T.INSERT$
, T.DELETE$
, T.REFOLDNAME
, T.REFNEWNAME
, SYS.DBMS_METADATA_UTIL.IS_SCHEMANAME_EXISTS(T.DEFINITION)
, -- BUG 4352110: STRIP NULLS
FROM DEFINITION
, WHENCLAUSE REPLACE(T.DEFINITION
, CHR(0))
, SYS.DBMS_METADATA_UTIL.PARSE_TRIGGER_DEFINITION(O.OWNER_NAME
, O.NAME
, REPLACE(T.DEFINITION
, CHR(0)))
, REPLACE(T.WHENCLAUSE
, CHR(0))
, SYS.DBMS_METADATA_UTIL.LONG2CLOB(T.ACTIONSIZE
, 'SYS.TRIGGER$'
, 'ACTION#'
, T.ROWID)
, NULL
, T.ACTIONSIZE
, T.ENABLED
, T.PROPERTY
, T.SYS_EVTS
, T.NTTRIGCOL
, T.NTTRIGATT
, (SELECT NTCOL.NAME
FROM SYS.VIEWTRCOL$ NTCOL
WHERE BITAND(T.PROPERTY
, 63)>= 32
AND T.BASEOBJECT = NTCOL.OBJ#
AND T.NTTRIGCOL = NTCOL.INTCOL#
AND T.NTTRIGATT = NTCOL.ATTRIBUTE#)
, T.REFPRTNAME
, T.ACTIONLINENO
, CAST(MULTISET(SELECT *
FROM KU$_TRIGGERCOL_VIEW TV
WHERE TV.OBJ_NUM=T.OBJ# ) AS KU$_TRIGGERCOL_LIST_T )
, CAST(MULTISET(SELECT *
FROM KU$_TRIGGERDEP_VIEW TD
WHERE TD.OBJ_NUM=T.OBJ# ) AS KU$_TRIGGERDEP_LIST_T )
, (SELECT VALUE(C)
FROM KU$_SWITCH_COMPILER_VIEW C
WHERE C.OBJ_NUM =O.OBJ_NUM)
FROM SYS.KU$_EDITION_SCHEMAOBJ_VIEW O
, SYS.TRIGGER$ T
WHERE T.OBJ# = O.OBJ_NUM AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))