| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-03  | 
  | 
  | 
View PDF | 
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 | NULL | 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 | 
See Also: