I wanted to store the picture files in the database. I have created a table with the column datatype BLOB. I would like
to know the sql command to insert a row which will insert a picture in that column and how to display the same once inserted? I have gone through the documentation, but its confusing me!
Thanks friends, i have inserted a row! but what are the options to view the picture which is stored in the database?
[Edited by ramya_ram on 04-04-2001 at 12:48 AM]
04-03-2001, 09:05 AM
no as far as i know you cannot insert a lob value using simple sql commands u can do it thru sql loader or dbms_lob package or oci if interested mail me at firstname.lastname@example.org
04-03-2001, 09:23 AM
You can also use SQL Loader to insert rows with pictures. Place a picture to file, specify its name in text file.
CREATE TABLE SAMPLE.EMP_PHOTO
EMPNO CHAR(6) NOT NULL,
PHOTO_FORMAT VARCHAR2(10) NOT NULL,