Insert statement with HEXTORAW : HEXTORAW « Large Objects « Oracle PL / SQL

1. Oracle PL / SQL
2. Large Objects
3. HEXTORAW

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.

 

Related examples in the same category