Oracle Database 11g Building Oracle XML DB Applications

Binary XMLType

Binary XML storage is a new XMLType storage format in Oracle Database 11g. It is created with the STORE AS BINARY XML syntax.

Creating Binary XMLType

The following example creates a binary XMLType column in a relational table (create_bin_tbl.sql):

Listing 12-7 Creating a Binary XMLType Column

CREATE TABLE contact_binary_tbl (id NUMBER, contact XMLType)

XMLType COLUMN contact

STORE AS SECUREFILE

BINARY XML (TABLESPACE USERS

             RETENTION AUTO KEEP_DUPLICATES

             COMPRESS HIGH

             STORAGE (INITIAL 4K NEXT 32K));

The binary XML storage is specified using the XMLType COLUMN [column_name] STORE AS SECUREFILE BINARY XML syntax. SECUREFILE, which is optional, allows the XMLType to be stored in Oracle SecureFiles ...