Can you explain how to insert an image in table in oracle?
Insert image into a table:
Create the following table:
create table pics_table
(bfile_id number,
bfile_desc varchar2(30),
bfile_loc bfile,
bfile_type varchar2(4))
TABLESPACE appl_data
storage (initial 1m next 1m pctincrease 0)
Insert Query:
INSERT INTO pics_table
VALUES(4,'test image',bfilename('GIF_FILES','Test.JPG'),'JPEG');
