VIEW: SYS.KU$_DIMENSION_VIEW

Source

View Text - Preformatted

select '1','0',
         d.obj#, value(o),
         d.dimtextlen,
         sys.dbms_metadata_util.long2clob(d.dimtextlen,
                                        'SYS.DIM$',
                                        'DIMTEXT',
                                        d.rowid)
  from sys.ku$_schemaobj_view o, sys.dim$ d
  where d.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'
, '0'
, D.OBJ#
, VALUE(O)
, D.DIMTEXTLEN
, SYS.DBMS_METADATA_UTIL.LONG2CLOB(D.DIMTEXTLEN
, 'SYS.DIM$'
, 'DIMTEXT'
, D.ROWID)
FROM SYS.KU$_SCHEMAOBJ_VIEW O
, SYS.DIM$ D
WHERE D.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' ))