Interested to Buy Any Domain ? << Click Here >> for more details...
how to insert the image in table
- 2 Answers
- 7042 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 is a read write transaction in oracle?
what is difference between sql plus and sql*plus? (not sql and sql plus).
What are oracle functions?
What are the factors causing the reparsing of SQL statements in SGA?
How does oracle handle read consistency?
What are the different approaches used by Optimizer in choosing an execution plan ?
what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
What is private procedure oracle?
What is a shared pool?
query to find the maximum no persons with same age(age colomn) from emp table
What does a Control file Contain ?
What is using clause and give example?
Oracle General 
