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 ;
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