how to insert the image in table
- 2 Answers
- 6372 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 tns service name?
Explain oracle insert into command?
What is the use of Redo Log Information ?
What are dml statements in oracle?
How to get a list of all user accounts in the database?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
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?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Name the various constraints used in oracle?
What is the usage of analyze command in oracle?
What is an Index ?
how may join possible between (requisition with purchase order)
Oracle General 
