Oracle PL/SQL Tutorial/Conversion Functions/HEXTORAW

HEXTORAW

   <source lang="sql">

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></source>

Table with clob and blob column

   <source lang="sql">

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></source>