ALL_XML_SCHEMAS

ALL_XML_SCHEMAS describes the registered XML schemas accessible to the current user.

Related Views

DBA_XML_SCHEMAS describes all registered XML schemas in the database.
USER_XML_SCHEMAS describes the registered XML schemas owned by the current user. This view does not display the OWNER column.

Column	Datatype	Description
`OWNER`	`VARCHAR2(30)`	Owner of the XML schema
`SCHEMA_URL`	`VARCHAR2(700)`	Schema URL of the XML schema
`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(767)`	Fully qualified schema URL
`HIER_TYPE`	`VARCHAR2(11)`	Type of hierarchy for which the schema is enabled: `NONE` `RESMETADATA` `CONTENTS`
`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`)