Answer Posted / 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 list all tables in your schema?

1113

---

How to load excel data sheet to oracle database

1072

---

Can a formula column be obtained through a select statement ?

2377

---

Can you tell me how to add new column in existing views?how?How is possible?

1513

---

How to set a transaction to be read only in oracle?

1137

---

What is an oracle wallet?

988

---

How to create a new tablespace in oracle?

1030

---

What are the differences between number and binary_float in oracle?

1143

---

What is bulk load in oracle?

1121

---

How to estimate disk space needed for an export job?

1102

---

Whats the benefit of dbms_stats over analyze?

2064

---

Give the constructs of a package, function or a procedure.

1094

---

Explain the use of show option in imp command.

1142

---

How to end the current transaction in oracle?

1066

---

How to name query output columns in oracle?

1237

---