VIEW: SYS.ALL_XMLTYPE_COLS

Source

View Text - Preformatted

((select s.sys_nc_oid$ as SCHEMA_ID,
       s.xmldata.schema_url as SCHEMA_URL, --schema URL for the column
       c.name as COL_NAME,  --name of the relational column
       (select c1.name from sys.col$ c1 where c1.intcol# = op.objcol and
        c1.obj# = op.obj#) QUALIFIED_COL_NAME,
       o.name as TABLE_NAME, --name of the parent table
       u.name as TABLE_OWNER --parent table owner
from xdb.xdb$schema s, sys.opqtype$ op, sys.col$ c, sys.obj$ o, sys.user$ u,
     all_tables a
where o.type# = 2 and
o.obj# = op.obj# and
o.obj# = c.obj# and
op.schemaoid = s.sys_nc_oid$ and
o.owner# = u.user# and
c.intcol# = op.intcol# and
o.name = a.table_name and
u.name = a.owner)
UNION
(select NULL as SCHEMA_ID,
       NULL as SCHEMA_URL, --schema URL for the column
       c.name as COL_NAME,  --name of the relational column
       (select c1.name from sys.col$ c1 where c1.intcol# = op.objcol and
        c1.obj# = op.obj#) QUALIFIED_COL_NAME,
       o.name as TABLE_NAME, --name of the parent table
       u.name as TABLE_OWNER --parent table owner
from sys.opqtype$ op, sys.col$ c, sys.obj$ o, sys.user$ u,
     all_tables a
where o.type# = 2 and
o.obj# = op.obj# and
o.obj# = c.obj# and
o.owner# = u.user# and
c.intcol# = op.intcol# and
o.name = a.table_name and
u.name = a.owner and op.schemaoid IS NULL))

View Text - HTML Formatted

((SELECT S.SYS_NC_OID$ AS SCHEMA_ID
, S.XMLDATA.SCHEMA_URL AS SCHEMA_URL
, --SCHEMA URL FOR THE COLUMN C.NAME AS COL_NAME
, --NAME OF THE RELATIONAL COLUMN (SELECT C1.NAME
FROM SYS.COL$ C1
WHERE C1.INTCOL# = OP.OBJCOL AND C1.OBJ# = OP.OBJ#) QUALIFIED_COL_NAME
, O.NAME AS TABLE_NAME
, --NAME OF THE PARENT TABLE U.NAME AS TABLE_OWNER --PARENT TABLE OWNER FROM XDB.XDB$SCHEMA S
, SYS.OPQTYPE$ OP
, SYS.COL$ C
, SYS.OBJ$ O
, SYS.USER$ U
, ALL_TABLES A WHERE O.TYPE# = 2 AND O.OBJ# = OP.OBJ# AND O.OBJ# = C.OBJ# AND OP.SCHEMAOID = S.SYS_NC_OID$ AND O.OWNER# = U.USER# AND C.INTCOL# = OP.INTCOL# AND O.NAME = A.TABLE_NAME AND U.NAME = A.OWNER) UNION (SELECT NULL AS SCHEMA_ID
, NULL AS SCHEMA_URL
, --SCHEMA URL FOR THE COLUMN C.NAME AS COL_NAME
, --NAME OF THE RELATIONAL COLUMN (SELECT C1.NAME
FROM SYS.COL$ C1
WHERE C1.INTCOL# = OP.OBJCOL AND C1.OBJ# = OP.OBJ#) QUALIFIED_COL_NAME
, O.NAME AS TABLE_NAME
, --NAME OF THE PARENT TABLE U.NAME AS TABLE_OWNER --PARENT TABLE OWNER FROM SYS.OPQTYPE$ OP
, SYS.COL$ C
, SYS.OBJ$ O
, SYS.USER$ U
, ALL_TABLES A WHERE O.TYPE# = 2 AND O.OBJ# = OP.OBJ# AND O.OBJ# = C.OBJ# AND O.OWNER# = U.USER# AND C.INTCOL# = OP.INTCOL# AND O.NAME = A.TABLE_NAME AND U.NAME = A.OWNER
AND OP.SCHEMAOID IS NULL))