how to insert the image in table

Question Posted / shabbirmca

2 Answers
5980 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to insert the image in table..

Answer / s. senthil kumar

HOW TO CREATE TABLE FOR IMAGE FILE?

create table image_table (
file_id number,
file_desc varchar2(30),
file_loc bfile,
file_type varchar2(4));

HOW TO INSERT IMAGE FILE IN TABLE?

INSERT INTO image_table
VALUES(1,'Senthil
photo',bfilename('c:\photos','Kanneer.jpg'),'JPEG');

Is This Answer Correct ?

8 Yes

1 No

how to insert the image in table..

Answer / dinesh gawande

Photographs and pictures can be inserted in the database
using BLOB/CLOB datatypes. You can use BLOB to insert the
image. There is one more datatype called Longraw but I
think BLOB is better because one table can have only one
longraw data type.

This task is covered in the Oracle documentation:

http://download-
west.oracle.com/docs/cd/B10501_01/appdev.920/a88786/mm_uses.
htm#600943

All the best.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer