whyme_at_nowhere.com wrote in message news:<9i7ngukir0eun4mgs3ipr3en4ccfbgt7k8_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
Use DBMS_LOB package. Read docs at,
http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/dbms_lob.htm#998100
Received on Sun Jun 16 2002 - 01:33:04 CDT
