ALL_XML_SCHEMAS
ALL_XML_SCHEMAS describes the registered XML schemas accessible to the current user.
Related Views
-
DBA_XML_SCHEMASdescribes all registered XML schemas in the database. -
USER_XML_SCHEMASdescribes the registered XML schemas owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(128) |
Owner of the XML schema | |
SCHEMA_URL |
VARCHAR2(700) |
Schema URL of the XML schema Refer to the See Also note below for links to more information about the |
|
LOCAL |
VARCHAR2(3) |
Indicates whether the XML schema is local (YES) or global (NO) |
|
SCHEMA |
XMLTYPE |
XML schema document | |
INT_OBJNAME |
VARCHAR2(4000) |
Internal database object name for the schema | |
QUAL_SCHEMA_URL |
VARCHAR2(865) |
Fully qualified schema URL | |
HIER_TYPE |
VARCHAR2(11) |
Type of hierarchy for which the schema is enabled:
|
|
BINARY |
VARCHAR2(3) |
Indicates whether the XML Schema is registered for binary encoding usage (YES) or not (NO) |
|
SCHEMA_ID |
RAW(16) |
Opaque schema identifier (16 bytes) | |
HIDDEN |
VARCHAR2(3) |
Indicates whether the XML Schema has been deleted in hidden mode (YES) or not (NO) |
See Also:
-
Oracle XML DB Developer’s Guide for information about registering an XML schema with Oracle XML DB
-
Oracle XML DB Developer’s Guide for information about restrictions for an XML schema URL