Wednesday, 23 October 2013

BLOB Datatype

BLOB : Binary Large Object  is a varying-length binary string that can be up to 2,147,483,647 characters long. Like other binary types, BLOB strings are not associated with a code page. In addition, BLOB strings do not hold character data.

Example: 
create table TABLE_BLOB
( id number,
  data blob);
  
 insert into table_blob values(1,utl_raw.cast_to_raw('Dhanunjay')); 
  
 select * from TABLE_BLOB ;

No comments:

Post a Comment