VIEW: SYS.KU$_XMLSCHEMA_VIEW

Source

View Text - Preformatted

select '1','0',
        u.user#, u.name, x.schema_url, x.schema_id,
        (case when x.local='YES' then 1 else 0 end
         + case when x.binary='YES' then 2 else 0 end),
        xlvl.lvl,
        value(s).getClobVal(),
        xdb.dbms_xdbutil_int.XMLSchemaStripUsername(XMLTYPE(
                                                    value(s).getClobVal()),
                                                    u.name)    -- stripped
    from sys.user$ u, sys.dba_xml_schemas x, xdb.xdb$schema s,
         sys.dba_xmlschema_level_view xlvl
    where x.owner=u.name and xlvl.schema_oid = x.schema_id and
          s.sys_nc_oid$ = x.schema_id and
          (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (u.user#, 0) OR
                EXISTS ( SELECT * FROM session_roles
                        WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, U.USER#
, U.NAME
, X.SCHEMA_URL
, X.SCHEMA_ID
, (CASE WHEN X.LOCAL='YES' THEN 1 ELSE 0 END + CASE WHEN X.BINARY='YES' THEN 2 ELSE 0 END)
, XLVL.LVL
, VALUE(S).GETCLOBVAL()
, XDB.DBMS_XDBUTIL_INT.XMLSCHEMASTRIPUSERNAME(XMLTYPE( VALUE(S).GETCLOBVAL())
, U.NAME) -- STRIPPED
FROM SYS.USER$ U
, SYS.DBA_XML_SCHEMAS X
, XDB.XDB$SCHEMA S
, SYS.DBA_XMLSCHEMA_LEVEL_VIEW XLVL
WHERE X.OWNER=U.NAME
AND XLVL.SCHEMA_OID = X.SCHEMA_ID AND S.SYS_NC_OID$ = X.SCHEMA_ID AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (U.USER#
, 0) OR EXISTS ( SELECT *
FROM SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))