Interested to Buy Any Domain ? << Click Here >> for more details...
how to insert the image in table
- 2 Answers
- 7036 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 |
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Explain the difference between a procedure and a function?
What is redo log?
what is shell?
How do I spool to a csv formatted file using sqlplus?
What is dictionary cache ?
How to select the name of employee who is getting maximum sal with out using subquery
What is Trace File ?
how will I find the first 5 highest salaried employees in each dept in oracle.
What is a SNAPSHOT ?
How do you store pictures in a database?
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
Oracle General 
