VIEW: SYS.KU$_XSNSPACE_VIEW

Source

View Text - Preformatted

select '1','0',
  (select value(xo) from ku$_xsobj_view xo where n.ns#=xo.id),
  n.ns#,
  n.acl#,
  n.hschema,
  n.hpname,
  n.hfname,
  n.ctime,
  n.mtime,
  n.description,
  (cast(multiset(select  value(a)
                 from ku$_xsnstmpl_attr_view a
                 where a.ns_num=n.ns#)
                 as ku$_xsnstmpl_attr_list_t))
  from xs$nstmpl n, xs$obj xo
  where xo.type = 7
    AND n.ns# = xo.id
    AND bitand(xo.flags,1) = 0                        /* not Oracle supplied */
    AND (SYS_CONTEXT('USERENV','CURRENT_USER') IN (xo.owner, 'SYS') OR
                EXISTS ( SELECT * FROM sys.session_roles
                        WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, (SELECT VALUE(XO)
FROM KU$_XSOBJ_VIEW XO
WHERE N.NS#=XO.ID)
, N.NS#
, N.ACL#
, N.HSCHEMA
, N.HPNAME
, N.HFNAME
, N.CTIME
, N.MTIME
, N.DESCRIPTION
, (CAST(MULTISET(SELECT VALUE(A)
FROM KU$_XSNSTMPL_ATTR_VIEW A
WHERE A.NS_NUM=N.NS#) AS KU$_XSNSTMPL_ATTR_LIST_T))
FROM XS$NSTMPL N
, XS$OBJ XO
WHERE XO.TYPE = 7
AND N.NS# = XO.ID
AND BITAND(XO.FLAGS
, 1) = 0 /* NOT ORACLE SUPPLIED */
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USER') IN (XO.OWNER
, 'SYS') OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))