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');

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.

How to upsert (update or insert into a table)?

0 Answers  

---

What is STATSPACK tool?

3 Answers   Wipro,

---

write a query that displays every Friday in a year with date?

5 Answers   Flipkart, HCL, TCS,

---

Explain compound trigger in oracle?

0 Answers  

---

if i am using dml statement in function. then i am writing select statement what was the output

2 Answers   MasterCard,

---

---

What is catalog in Oracle?

0 Answers   MCN Solutions,

---

How do I limit the number of rows returned by an oracle query after ordering?

0 Answers  

---

What is the relationship among database, tablespace and data file?

0 Answers  

---

What do database buffers contain?

0 Answers  

---

How to get a list of all user accounts in the database?

0 Answers  

---

How to call a sub procedure?

0 Answers  

---

When a form is invoked with call_form, Does oracle forms issues a save point ?

1 Answers   Oracle,

---