image data type

Hi,

How can i store images (gif or jpg) in Oracle8?
What is the data type and how to use it ?

Thanks

Nicolas

In LongRow You can store Pictures, Graphics Etc.
These dataTypes can not be used in Select Statements in SQL *Plus, They can be viewd in Front End applications.

To store, Again you have to use From end Tool Like Developer to Store Images ...
Thanks

can i use the data type Blob for storing images (jpg).
Can i do this:
create table photo (
id number(1)
image blob
)

And how to insert values ?

Thanks

Hi nic,

Yes, you can use BLOB as the data type. In addition you should be using DBMS_LOB package to insert the image into this BLOB type.

You can refer book : Oracle Built-in packages by Steven Feuerstein (O'Reilly publications) for further help.

thanks,
AD

Hi,

Could you give me an exemple of value insertion (with the Blob data type) .
Does the book exist in French ?

Thanks

Nic