PL/SQL   «Prev 

Syntax for Updating within Object Tables

Syntax for Creating Lob
Syntax for Creating Lob

Create Table

CREATE TABLE <table_name> The CREATE TABLE statement specifying the table name
<column_name> <lob_type>, The column name with the LOB data type
<column_name> <data_type>, …) The column name with other data type
LOB (lob_column_name) store asLOB parameters stipulating the way a LOB column is stored within the database
(TABLESPACE <tablespace_name>The tablespace name for storing the LOB column
CHUNK <value>The CHUNK value for manipulation of the LOB
PCTVERSION <value>The PCTVERSION for versioning of the LOB
CACHE / NOCACHEFor logging of the transactions within the redo log buffer
STORAGE <parameters>));The storage parameters

Updating within object tables

CREATE TABLE CUSTOMER_PHOTO_OBJ_TABLEThe CREATE TABLE statement specifying the table name
CUSTOMER_ID NUMBER (10),The column name with the NUMBER data type
CUSTOMER_PHOTO BLOB,The column name with the LOB data type
CREATED_DATE DATE)The column name with the DATE data type
LOB (CUSTOMER_PHOTO) STORE ASLOB parameters stipulating the way a LOB column is stored within the database
(CHUNK 4096The CHUNK value for manipulation of the LOB
PCTVERSION 5The PCTVERSION for versioning of the LOB
NOCACHE LOGGINGFor logging of the transactions within the redo log buffer
STORAGE (MAXEXTENTS 5));The storage parameters