Insert statement with HEXTORAW
SQL> SQL> CREATE TABLE lobdemo ( 2 key NUMBER, 3 clob_col CLOB, 4 blob_col BLOB); Table created. SQL> SQL> INSERT INTO lobdemo (key, clob_col, blob_col) 2 VALUES (50, 'This is a character literal', 3 HEXTORAW('FEFEFEFEFEFEFEFEFEFE')); 1 row created. SQL> SQL> INSERT INTO lobdemo (key, clob_col, blob_col) 2 VALUES (51, 'This is another character literal', 3 HEXTORAW('ABABABABABABABABABAB')); 1 row created. SQL> SQL> INSERT INTO lobdemo 2 SELECT key + 10, clob_col, blob_col 3 FROM lobdemo 4 WHERE key IN (50, 51); 2 rows created. SQL> SQL> SQL> drop table lobdemo; Table dropped.
1. | HEXTORAW function |