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 ...

Get Oracle Database 11g Building Oracle XML DB Applications now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.