Re: inserting images into tables

Yes, you can store an image in a BLOB (Binary Large OBject) column. You manipulate LOBS (Large OBjects) using the DBMS_LOB package.

Best!

Randall Roberts
[remove <nsp> from email address when replying by email]

Bala <databala_at_yahoo.com> wrote in message news:dfe6bdb1.0105202303.1b625f98_at_posting.google.com...
> "Guang Mei" <gmei_at_proteome.com> wrote in message
 news:<77gN6.1061$du2.100385_at_news.shore.net>...
> > Hi,
> >
> > I would not store image within oracle db, because it takes too long to
 save
> > and retrive image. You can store images in operate system and only store
> > image file's full directory and file name in db.
> >
> > HTH
> >
> > "Omar Malik" <obNOSPAMmar_at_hotmail.com> wrote in message
> > news:9dtrbt01tqd_at_enews4.newsguy.com...
> > > hey all
> > > I have a table called image_table and I want to place images in it so
 that
 I
> > > can retrieve them as I query my database. read_image_file command is
 not
> > > helping much under the when_new_form_instance. Please give me a good
> > > approach as to how to add to a table.
> > >
> > > Thanks
>
>
> i also would like to know if there is any way to store an image file
> in the database, rather than just storing the address,and storing the
> file else where. some times it's a real necessity
> > >
> > >
Received on Wed May 23 2001 - 01:10:05 CEST