how to insert the image in table

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.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is BBED in Oracle?

908


What is the maximum limit on the number of columns in a table?

771


How to define an oracle cursor variable?

781


What is an oracle wallet?

689


what is port in oracle? how is it related to database application.

1700


What is redo log?

812


What is flashback in Oracle?

757


What is recovery manager(rman) backup in Oracle?

901


How to export your connection information to a file?

827


What is the difference between postgresql and oracle?

749


Can we insert data in view oracle?

747


What are the predefined tablespaces in a database?

782


How can I create database in oracle?

764


Can we create database in oracle using command line ?

829


Explain the use of constraints option in exp command.

786