Interested to Buy Any Domain ? << Click Here >> for more details...
how to insert the image in table
- 2 Answers
- 6831 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 |
How to check your oracle database 10g xe installation?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to set up autotrace for a user account?
when do u go for hash partitioning?
What happens if you lost a data file?
Can we call procedure inside function in oracle?
difference between imlicit cursor and explicit cursor ?
What are the differences between char and varchar2 in oracle?
What is the difference between primary key and unique key and foreign key in oracle?
What is Trigger in Oracle?
What is the difference between column level constraints and table level constraints?
14 Answers IBM, TCS,
What are the attributes of cursor?
Oracle General 
