How to add a blob in an Oracle 8i table?
From: <whyme_at_nowhere.com>
Date: Sun, 16 Jun 2002 01:06:56 GMT
Message-ID: <v4pnguco7fb4r127joqcipgkibr1sf9r9e_at_4ax.com>
loc_id NUMBER(5),
CONSTRAINT faculty_f_id_pk PRIMARY KEY(f_id), CONSTRAINT faculty_loc_id_fk FOREIGN KEY (loc_id) REFERENCES location(loc_id));
Date: Sun, 16 Jun 2002 01:06:56 GMT
Message-ID: <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 Sun Jun 16 2002 - 03:06:56 CEST