EMPTY_BLOB
A BLOB
column can be initialized to a zero-length, empty BLOB
using the EMPTY_BLOB
function. This function initializes the LOB to a non-null value, so can be used for initializing any BLOB
that has been declared as NOT NULL
.
This function is not supported in TimesTen Scaleout.
SQL syntax
EMPTY_BLOB ()
Parameters
EMPTY_BLOB
has no parameters.
Description
You can only use EMPTY_BLOB
in the VALUES
clause of an INSERT
statement or the SET
clause of an UPDATE
statement.
Examples
The following example uses the EMPTY_BLOB
function to initialize a non-null BLOB
column to a zero-length value.
Command> CREATE TABLE blob_content (id NUMBER PRIMARY KEY, blob_column BLOB NOT NULL); -- Does not allow a NULL value Command> INSERT INTO blob_content (id, blob_column) VALUES (1, EMPTY_BLOB( ) ); 1 row inserted.