DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.ALL_XML_SCHEMAS

Object Details
Object Name: ALL_XML_SCHEMAS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Description of all XML Schemas that user has privilege to reference

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128)
Owner of the XML Schema
SCHEMA_URL VARCHAR2 (700)
Schema URL of the XML Schema
LOCAL VARCHAR2 (3)
Is this XML Schema local or global
SCHEMA XMLTYPE (64)
The XML Schema document
INT_OBJNAME VARCHAR2 (4000)
The internal database object name for the schema
QUAL_SCHEMA_URL VARCHAR2 (865)
The fully qualified schema URL
HIER_TYPE VARCHAR2 (11)
The type of hierarchy for which the schema is enabled
BINARY VARCHAR2 (3)
Is this XML Schema registered for binary encoding usage?
SCHEMA_ID RAW (16)
16 byte opaque schema identifier
HIDDEN VARCHAR2 (3)
Has this XML Schema been deleted in hidden mode?
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      SCHEMA_URL
,      LOCAL
,      SCHEMA
,      INT_OBJNAME
,      QUAL_SCHEMA_URL
,      HIER_TYPE
,      BINARY
,      SCHEMA_ID
,      HIDDEN
FROM SYS.ALL_XML_SCHEMAS;

Dependencies

[top of page]

SYS.ALL_XML_SCHEMAS references the following:

SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
TableUSER$
TYPEXMLTYPE
SchemaXDB
PL/SQL PackageDBMS_CSX_INT - show dependent code
PL/SQL PackageDBMS_XMLSCHEMA_INT - show dependent code
TableXDB$SCHEMA
SYS.ALL_XML_SCHEMAS is referenced by following:

SchemaPUBLIC
SynonymALL_XML_SCHEMAS
SchemaSYS
ViewALL_XML_SCHEMA_ATTRIBUTES
ViewALL_XML_SCHEMA_COMPLEX_TYPES
ViewALL_XML_SCHEMA_ELEMENTS
ViewALL_XML_SCHEMA_NAMESPACES
ViewALL_XML_SCHEMA_SIMPLE_TYPES
ViewALL_XML_SCHEMA_SUBSTGRP_HEAD
ViewALL_XML_SCHEMA_SUBSTGRP_MBRS
ProcedureVALIDATE_ORDIM - show dependent code