Re: How to add a blob in an Oracle 8i table?

Hi,

Take a look at the DBMS_LOB package,
everything is in to manage large objects

HTH Chris

whyme_at_nowhere.com wrote in message news:<v4pnguco7fb4r127joqcipgkibr1sf9r9e_at_4ax.com>...
> CREATE TABLE faculty
> (f_id NUMBER(6),
> f_last VARCHAR2(30),
> f_first VARCHAR2(30),
> f_mi CHAR(1),
> loc_id NUMBER(5),
> f_phone VARCHAR2(10),
> f_rank VARCHAR2(8),
> f_pin NUMBER(4),
> f_image BLOB,
> CONSTRAINT faculty_f_id_pk PRIMARY KEY(f_id),
> CONSTRAINT faculty_loc_id_fk FOREIGN KEY (loc_id) REFERENCES
> location(loc_id));
>
>
> INSERT INTO faculty VALUES
> (3, 'Williams', 'Jerry', 'F', 56, '7155555412', 'ASST', 8531,
> EMPTY_BLOB());
>
> When entering a record, how is the blob image entered? Do I use
> single quotes around the image field? DO I enter the name of the blob
> image if I know it? The name of the image is williams.jpg
>
> Thanks
Received on Mon Jun 17 2002 - 23:01:55 CEST