Message-Id: <10571.113109@fatcity.com> From: L Date: Thu, 27 Jul 2000 08:32:49 -0400 (EDT) Subject: Re: store image file in the database ? Can you help me on following two things: 1. how to insert or sqlloader or from ORACLE FORM into ORACLE database? 2. which tool can query and display image? Thanks On Thu, 27 Jul 2000, [iso-8859-1] paquette stephane wrote: > Hi, >=20 > You can use blob for the images, clob is for text. > We're using both, blob for .gif and .jpg and clob for > text. >=20 > Yes, you can query the images with the proper tool. >=20 > I do not think that you can change the format of an > image stored in Oracle.=20 >=20 > --- Herman Susantio a =E9crit=A0: > > hallo guys, > >=20 > > anyone knows how to store JPEG file in a database ? > > and in what datatype ? > > BLOB ? CLOB ? > >=20 > > can we do the query for the image ? > >=20 > > and if the image is already in the database, > > can we convert it into JPEG file ? > >=20 > > thank you > >=20 > > regards > >=20 > >=20 > >=20 > >=20 > >=20 > >=20 > > --=20 > > Author: Herman Susantio > > INET: Sherman@bcsis.com > >=20 > > Fat City Network Services -- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California -- Public Internet > > access / Mailing Lists > > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: ListGuru@fatcity.com (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). >=20 >=20 > =3D=3D=3D=3D=3D > Stephane Paquette > DBA Oracle > stephane_paquette@yahoo.com > spaquette@houra.fr > (33) 01 53 93 06 50 >=20 > __________________________________________________ > Do You Yahoo!? > Get Yahoo! Mail - Free email you can access from anywhere! > http://mail.yahoo.com/ > --=20 > Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D > INET: stephane_paquette@yahoo.com >=20 > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may