BLOB

BLOB, the binary LOB type, is used to store binary data.


SQL> CREATE TABLE my_blob(
  2          id INTEGER PRIMARY KEY,
  3          blob_column BLOB NOT NULL
  4  );

Table created.

SQL>
SQL>
SQL> INSERT INTO my_blob (id, blob_column) VALUES (1, TO_BLOB('1001'));

1 row created.

SQL> INSERT INTO my_blob (id, blob_column) VALUES (2, TO_BLOB('A0FF'));

1 row created.

SQL>
SQL>
SQL> SELECT id FROM my_blob;

        ID
----------
         1
         2

SQL>
SQL>
SQL> UPDATE my_blob
  2  SET blob_column = TO_BLOB('1110')
  3  WHERE id = 1;

1 row updated.

SQL>
Home »
Oracle »
Data types » 

BLOB:
  1. BLOB
  2. EMPTY_BLOB() stores an empty BLOB:
Related: