i want to store photos of student along with their resume in a database,
can it be possible to store it directly (without using front end) to oracle table?
Printable View
i want to store photos of student along with their resume in a database,
can it be possible to store it directly (without using front end) to oracle table?
i think yes!
BLOB is the data type provided to store images etc!
just give the blob (size);
blob is the deata type
To get Details of Blob follow this [URL="http://www.psoug.org/reference/dbms_lob.html"]link[/URL]
hi
u cannot store image directly,but u can store the address of the image in the table using datatype as a blob.ok bye
You can use either BLOB or LONG RAW for the purpose.
write a query to store picture in the database
you need to convert the picture to a stream of bytes and store to BLOB field
you need to create a column data type as BLOB and when ever you store image in to BLOB type column it will store in the form of Binary.
use blob datatype in oracle