Ravi wadalkar

• Jan 2nd, 2006

 

my dear it is clob

Ravi wadalkar

• Jan 2nd, 2006

 

sorry yar it is not clob but blob i.e binary large objects

Kin

• Apr 1st, 2006

 

Its clearly Blob datatype for storing images....

thumatinagaraju

• Nov 2nd, 2006

 

hi ya ur correct it's blob only .. bcz it's binary data naaa..

Nikhil_4_Oracle

• Mar 9th, 2007

 

HI ALL,

 YES its BLOB.....

 So wanna insert u r pic into oracle..!!!

Try this, 

/*Insert a Image into DataBase */

  

create or replace PROCEDURE INSERT_BLOB(filE_namE IN VARCHAR2,dir_name varchar2)

IS

tmp number;

f_lob     bfile;

b_lob   blob;

BEGIN

dbms_output.put_line('INSERT BLOB Program Starts');

dbms_output.put_line('--------------------------');

dbms_output.put_line('File Name :'||filE_namE);

dbms_output.put_line('--------------------------');

UPDATE  photograph SET image=empty_blob()

WHERE file_name =filE_namE

returning image INTO b_lob;

f_lob := bfilename( 'BIS_IMAGE_WORKSPACE',filE_namE);

dbms_lob.fileopen(f_lob,dbms_lob.file_readonly);

--dbms_lob.loadfromfile(b_lob,f_lob,dbms_lob.getlength(f_lob));               

insert into photograph values (111,user,sysdate,b_lob);

dbms_lob.fileclose(f_lob);

dbms_output.put_line('BLOB Successfully Inserted');

dbms_output.put_line('--------------------------');

commit;

dbms_output.put_line('File length is: '||dbms_lob.getlength( f_lob));

dbms_output.put_line('Loaded length is: '||dbms_lob.getlength(b_lob));

dbms_output.put_line('BLOB Committed.Program Ends');

dbms_output.put_line('--------------------------');

END inserT_bloB;

/

Regards,

Nikhil

goyal_tarun

• May 3rd, 2007

 

Hi,

BLOB is generally used to store pictures. It stands for Binary Large Object. The maximum storage limit is 4GB. There is also one limitation using BLOB, you can have only one column of type BLOB.

Cheers,
Tarun

Shankha

• Apr 17th, 2020

 

I greatly appreciate you for coming to this guide on “datatype is used to store picture” can be uploaded and retrieved. Yet I would discourage this store picture in a database because traditional RDBMS are not always designed to store such datatype. I am sure you have your motives to want to preserve photos in the database.
If you want to save images that you download somewhere, simply use the regular file system. When privacy issues exist, place the image data in a small repository that can not be accessed widely–then using PHP to pick up photos.
Blob is used to store images.

A 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. Besides, BLOB strings do not hold character data.