How to ad a blob value to a table

From: <whyme_at_nowhere.com>
Date: Sat, 15 Jun 2002 20:10:34 GMT
Message-ID: <9i7ngukir0eun4mgs3ipr3en4ccfbgt7k8@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 Sat Jun 15 2002 - 15:10:34 CDT