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.