XMLType Column Properties

This dialog box is displayed if you define a table column as type SYS.XMLTYPE and click the XMLType Properties button. For more information about XMLType storage models, see Oracle XML DB Developer's Guide.

Store As: Binary XML (data stored in compact, post-parse, XML schema-aware format; can be used with XML data that is not based on an XML schema), CLOB (data stored in Character Large Object instances), or Object Relational (data stored as a set of objects). Note that effective with Oracle Database Release 12.1, Store As CLOB for XMLType is deprecated.

XML Schema Owner: Owner of the XML schema.

XML Schema: Name of the XML Schema. For example: http://xmlns.oracle.com/xdb/XDBResource.xsd

Element: Select the desired element from the list of elements defined in the XML schema.

Allow Any Schema (only if Store As is Binary XML): Encodes all XML schema-based documents using an encoding based on the XML schema referenced by the document.

Allow Non-Schema (only if Store As is Binary XML): Encodes all XML schema-based documents using an encoding based on the referenced XML schema; encodes all non-schema-based documents using the non-schema-based encoding.