O'Reilly logo

Oracle Database 11g: Building Oracle XML DB Applications by Jinyu Wang

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required