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 delete a column in an existing table?

1072

---

How does one get the view definition of fixed views/tables?

1017

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2218

---

Differentiate between function and procedure in oracle.

1070

---

What is a partition in oracle?

1116

---

What is a lookup table in oracle?

971

---

What is null value in oracle?

1095

---

What is a cursor in oracle?

1170

---

Give the various rollback segment states.

1048

---

What are the different types of synonyms?

1133

---

How to drop an index in oracle?

1066

---

How do I connect to oracle?

1027

---

What is control file used for?

1196

---

Explain the blob datatype?

1071

---

How does the on-delete-cascade statement work?

1100

---