HEXTORAW : HEXTORAW « Conversion Functions « Oracle PL/SQL Tutorial

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

SQL>
SQL> CREATE TABLE myBlob
  2  (id NUMBER PRIMARY KEY,
  3   blob_data BLOB);

Table created.

SQL> INSERT INTO myBlob VALUES (2,HEXTORAW('AAAAAAAAAAAAAAAAAAAA'));

1 row created.

SQL>
SQL> drop table myBlob;

Table dropped.

SQL>