VIEW: SYS.KU$_TABCLST_VIEW

Source

View Text - Preformatted

select k.clstobj#, value(o),
     (select value(cz) from ku$_clst_view cz where cz.obj_num = k.clstobj#)
  from ku$_schemaobj_view o, clst$ k
  where o.obj_num = k.clstobj#
        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 K.CLSTOBJ#
, VALUE(O)
, (SELECT VALUE(CZ)
FROM KU$_CLST_VIEW CZ
WHERE CZ.OBJ_NUM = K.CLSTOBJ#)
FROM KU$_SCHEMAOBJ_VIEW O
, CLST$ K
WHERE O.OBJ_NUM = K.CLSTOBJ#
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))