Interested to Buy Any Domain ? << Click Here >> for more details...
how to insert the image in table
- 2 Answers
- 6942 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 are the benefits of ordbms?
how to unbreak sequence numbers during intereptions
State the various uses of dbcc command?
How to connect to a remote server?
What is Partitions in Table ?
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
What is data block in Oracle?
what is the syntax of DELETE command?
What is oracle and what are its different editions?
How to use values from other tables in update statements using oracle?
What is oracle open database communication (odbc)?
24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.
Oracle General 
