VIEW: SYS.KU$_EXP_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,
        null, null
    from sys.user$ u, sys.dba_xml_schemas x, sys.dba_xmlschema_level_view xlvl
    where x.owner=u.name and
          xlvl.schema_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
, NULL
, NULL
FROM SYS.USER$ U
, SYS.DBA_XML_SCHEMAS X
, SYS.DBA_XMLSCHEMA_LEVEL_VIEW XLVL
WHERE X.OWNER=U.NAME AND XLVL.SCHEMA_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' ))