BLOB
data type in the Oracle database has a varying length binary string. It is used to store two gigabytes of memory and for it, the length needs to be specified in bytes. An example to illustrate the usage of the BLOB
data type is given below :create table photos(name varchar(32) not null primary key, picture blob(10M));
select name,length(picture) from photos where name like '%logo%';