Interested to Buy Any Domain ? << Click Here >> for more details...
how to insert the image in table
- 2 Answers
- 6918 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
What is a select query statement in oracle?
What is difference between a formal and an actual parameter?
What is the difference between postgresql and oracle?
What is rich query?
How to change system global area (sga) in oracle?
How to sort the query output in oracle?
IS it possible to built the oracle database without setting the kernal parameters?
How to use existing values in update statements using oracle?
What do you mean by merge in oracle?
What is RULE-based approach to optimization ?
what is a view?
Oracle General 
