Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: store image file in the database ?

Re: store image file in the database ?

From: L <leed_at_chele.cais.net>
Date: Thu, 27 Jul 2000 08:32:49 -0400 (EDT)
Message-Id: <10571.113109@fatcity.com>


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 <Sherman_at_bcsis.com> 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_at_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_at_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_at_yahoo.com
> spaquette_at_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_at_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_at_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
Received on Thu Jul 27 2000 - 07:32:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US