Table with clob and blob column : HEXTORAW « Conversion Functions « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Conversion Functions
3. HEXTORAW

SQL>
SQL> create table myTable
  2  (key NUMBER PRIMARY KEY
  3  ,col_blob BLOB
  4  ,col_clob CLOB);

Table created.

SQL>
SQL>
SQL> INSERT INTO myTable(key, col_blob, col_clob) VALUES (1, HEXTORAW('101F'), 'ZYXW');

1 row created.

SQL>
SQL> INSERT INTO myTable(key, col_blob, col_clob) VALUES(2, HEXTORAW('111101F'), 'ABCD');

1 row created.

SQL>
SQL> drop table myTable;

Table dropped.

SQL>
SQL>