Search This Blog

Monday, November 18, 2013

BLOB (Binary Large Object) Oracle Data Type

Oracle > Data Type > BLOB

A BLOB (Binary Large Object) can hold up to 4 GB of data. BLOB's are designed for storing digitized information like images, audio, video.

Example:

CREATE TABLE blob_table (id NUMBER, doc BLOB);
INSERT INTO blob_table VALUES (1, EMPTY_BLOB());

select * from blob_table