How Are XML Schema-Based XMLType Structures Stored?
XML Schema-based XMLType structures are stored in one of the following ways: In underlying object type columns. This is the default storage mechanism. SQL object types can be created optionally during the XML schema registration process. See “Creating XMLType Tables and Columns Based on XML Schema”. See “Specifying SQL Object Type Names with SQLName, SQLType Attributes”. In a single underlying LOB column. Here the storage choice is specified in the STORE AS clause of the CREATE TABLE statement: CREATE TABLE po_tab OF xmltype STORE AS CLOB ELEMENT “http://www.oracle.com/PO.xsd#PurchaseOrder”; Design criteria for storing XML data are discussed inChapter 2, “Getting Started with Oracle XML DB” and Chapter 3, “Using Oracle XML DB”.
