Oracle Compliance with SQL/XML
The XML data type in the standard is XML
. The Oracle equivalent data type is XMLType
. A feature of the standard is considered to be fully supported if the only difference between Oracle and the standard is the spelling of the data type name.
Table C-3 describes Oracle's support for the features of SQL/XML.
Table C-3 Oracle Support for Features of SQL/XML
Feature ID, Feature | Support |
---|---|
X010, XML type |
Oracle fully supports this feature. |
X011, Arrays of XML types |
Oracle supports this feature using named array types |
X012, Multisets of XML type |
The Oracle equivalent of a multiset of XML type is a nested table with a single column of XML type. |
X013, Distinct types of XML |
A distinct type can be emulated using an object type with a single attribute. |
X014, Attributes of XML type |
In Oracle, attributes of object types may be of type |
X015, Fields of XML type |
Oracle object types may be used instead of row types; Oracle supports object types with attributes of |
X016, Persistent XML values |
Oracle fully supports this feature. |
X020, |
Oracle fully supports this feature. |
X025, |
Oracle supports this feature, with the following restrictions:
Oracle extends this feature with the ability to cast to type |
X031, |
Oracle fully supports this feature. |
X032, |
Oracle fully supports this feature. |
X034, |
Oracle fully supports this feature. |
X035, |
Oracle fully supports this feature. |
X036, |
Oracle fully supports this feature. |
X036, |
Oracle fully supports this feature. |
X038, |
The Oracle |
X040, Basic table mapping |
Oracle table mappings are available through a Java interface and through a package. Oracle table mappings have been generalized to map queries and not just tables. To map only a table:
Oracle does not support the following element of this feature:
|
X041, Basic table mapping: null absent |
See X040. |
X042, Basic table mapping: null as nil |
See X040. |
X043, Basic table mapping: table as forest |
See X040. |
X044, Basic table mapping: table as element |
See X040. |
X045, Basic table mapping: with target namespace |
See X040. |
X046, Basic table mapping: data mapping |
See X040. |
X047, Basic table mapping: metadata mapping |
See X040. |
X049, Basic table mapping: hex encoding |
See X040. |
X060, |
Oracle does not support the { |
X061, |
Oracle does not support the { |
X069, |
Oracle extends this feature with the ability to specify an indent size. |
X070, |
Oracle supports this feature, with this restriction:
Oracle extends this feature as follows: the standard requires a target data type; Oracle defaults to |
X071, |
Oracle fully supports this feature. |
X072, |
Oracle fully supports this feature. |
X073, |
Oracle fully supports this feature. |
X074, |
Oracle fully supports this feature. |
X075, |
Oracle fully supports this feature. |
X076, |
Use |
X077, |
Oracle fully supports this feature. |
X080, Namespaces in XML publishing |
In the Oracle implementation of |
X086, XML namespace declarations in |
Oracle fully supports this feature. |
X090, XML document predicate |
In Oracle, you can test whether an XML value is a document by using the |
X096, |
Oracle fully supports this feature, with this exception: Oracle only supports passing by value, so the keywords |
X120, XML parameters in SQL routines |
Oracle fully supports this feature. |
X121, XML parameters in external routines |
Oracle supports XML values passed to external routines using a non-standard interface. |
X141, |
The |
X142, |
The |
X143, |
The |
X144, |
The |
X145, |
The |
X151, |
The |
X156, |
The |
X157, |
The |
X160, Basic Information Schema for registered XML Schemas |
The Oracle static data dictionary view |
X161, Advanced Information Schema for registered XML Schemas |
Oracle does not have static data dictionary views corresponding to |
X191, |
Oracle does not support this syntax. However, a column of a table can be constrained by a registered XML Schema, in which case all values of the column will be of |
X200, |
Oracle fully supports the following elements of this feature:
Oracle only supports passing by value, so the keywords |
X201, |
See X200. |
X203, |
See X200. |
X204, |
See X200. |
X206, |
See X200. |
X221, XML passing mechanism |
Oracle supports the |
X232, |
Oracle does not support this syntax as a type modifier, but the Oracle |
X241, |
Oracle does not support this syntax. In Oracle, the behavior of the publishing functions ( |
X251, Persistent XML values of |
Oracle fully supports this feature. |
X252, Persistent values of type |
Oracle fully supports this feature. |
X256, Persistent values of |
Oracle fully supports this feature. |
X260, XML type, |
Oracle does not support this syntax. However, a column of a table may be constrained by a top-level element in a registered XML Schema. |
X263, XML type: |
Oracle does not support this syntax. However, a column of a table may be constrained by a top-level element in the "no name" namespace of a registered XML Schema. |
X264, XML type: schema location |
Oracle does not support this syntax. However, a column of a table may be constrained by a registered XML Schema that is identified by a schema location. |
X271, XMLValidate: data driven case |
The |
X272, XMLValidate: |
The |
X273, XMLValidate: |
The |
X274, XMLValidate: schema location |
The |
X281, XMLValidate with |
The |
X286, XMLValidate: |
The |
X300, |
Oracle does not support reverse axes in the column path expressions. Aside from that restriction, Oracle fully supports the following elements of this feature:
Oracle only supports passing by value, so the keywords |
X302, |
See X300. |
X303, |
See X300. |
X304, |
See X300. |
X305, |
See X300. |