Home » Interview » Technology

Can you explain how to insert an image in table in oracle?

Correct Answer: 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','TestJPG'),'JPEG');

← Previous Question Next Question→

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion