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 an oracle cursor variable?

1075

---

what are the advantages of running a database in archive log mode?

2203

---

What is partitioned table in Oracle?

1189

---

Can we save images in a database and if yes, how?

1065

---

how to join query for one source type is oracle another source type is sql server ?

2425

---

What is raw datatype?

1136

---

How many categories of data types?

996

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2131

---

How to retrieve values from data fields in record variables?

1116

---

Can we store images in oracle database?

1009

---

What is a sub query? What are its various types?

1179

---

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

1021

---

What are the different types of record groups in oracle? Explain each of them

1025

---

How to add another datafile to a tablespace?

1040

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2136

---