How to Insert Blob Datatype Values in Oracle 11g Database Through SQL*Plus

Question

I have created a table with Blob datatype but I do not know how to insert values into the table or view the table content using SQL*Plus. Please help me.

Answer 1

It depends on what kind of data you want put into a BLOB. Let's consider the table:

create table b1(id number , b blob);

If your data represented as hex-string you should use TO_BLOB function

insert into b1 values(1,to_blob('FF3311121212EE3a'));

SQLPLUS also shows BLOBs as hex-string

select * from b1;

----- -----------------------------------
   ID                                   B
----- -----------------------------------
    1 FF3311121212EE3A

Please refer Oracle documentation on Using LOBs