Interested to Buy Any Domain ? << Click Here >> for more details...
how to insert the image in table
- 2 Answers
- 6937 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 difference between a formal and an actual parameter?
how to store only time in a data base table
What is SQL Tuning Advisor in Oracle?
how to make an oracle object
Explain the use of indexes option in imp command.
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
How to concatenate two text values in oracle?
What are the components of logical database structure in oracle database?
How will you differentiate between varchar & varchar2?
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
Name the various constraints used in oracle?
How to execute the package in oracle?
Oracle General 
