SQL>
SQL>
SQL> CREATE TABLE lobdemo (
2 key NUMBER PRIMARY KEY,
3 clob_col CLOB,
4 blob_col BLOB,
5 bfile_col BFILE
6 );
Table created.
SQL>
SQL> INSERT INTO lobdemo (key, clob_col, blob_col, bfile_col)
2 VALUES (50, "This is a character literal",
3 HEXTORAW("FEFEFEFEFEFEFEFEFEFE"),
4 NULL);
1 row created.
SQL>
SQL> INSERT INTO lobdemo (key, clob_col, blob_col, bfile_col)
2 VALUES (51, "This is another character literal",
3 HEXTORAW("ABABABABABABABABABAB"),
4 NULL);
1 row created.
SQL>
SQL> UPDATE lobdemo
2 SET blob_col = HEXTORAW("CDCDCDCDCDCDCDCDCDCDCDCD")
3 WHERE key IN (50, 51);
2 rows updated.
SQL>
SQL>
SQL> DROP TABLE lobdemo;
Table dropped.
SQL>
SQL>