VIEW: SYS.KU$_USER_PREF_STATS_VIEW

Source

View Text - Preformatted

select '1', '0', o.obj#,
         (select value(sov) from ku$_schemaobj_view sov
          where sov.obj_num = o.obj#),
          cast(multiset(select value(usv) from ku$_up_stats_view usv
                        where usv.obj_num = o.obj#
                       ) as ku$_up_stats_list_t
              )
  from   sys.obj$ o
  where  exists (select 1 from sys.optstat_user_prefs$ opt
                 where o.obj# = opt.obj#) and
         (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner#, 0) OR
              EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, O.OBJ#
, (SELECT VALUE(SOV)
FROM KU$_SCHEMAOBJ_VIEW SOV
WHERE SOV.OBJ_NUM = O.OBJ#)
, CAST(MULTISET(SELECT VALUE(USV)
FROM KU$_UP_STATS_VIEW USV
WHERE USV.OBJ_NUM = O.OBJ# ) AS KU$_UP_STATS_LIST_T )
FROM SYS.OBJ$ O
WHERE EXISTS (SELECT 1
FROM SYS.OPTSTAT_USER_PREFS$ OPT
WHERE O.OBJ# = OPT.OBJ#) AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER#
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))