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.

What is the usage of analyze command in oracle?

1032

---

What does sharding mean?

946

---

What do you understand by database schema and what does it hold?

1177

---

What is an oracle user account?

930

---

How do I know if oracle client is installed on windows?

953

---

How to import one table back from a dump file?

969

---

Explain the difference between replace() and translate() functions in oracle?

974

---

How to get maxsal , minsal, ename department wise in single query

1499

---

How to use subqueries with the in operator using oracle?

1030

---

What is save point in oracle database?

1239

---

Give the various rollback segment states.

999

---

What is the relation of a user account and a schema?

1062

---

How to rename an index?

995

---

What is Data Dictionary Cache in Oracle?

1117

---

How to get a create statement for an existing table?

906

---