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>