Re: can gif or jpg files be stored in a table ?

From: Ranganathan Chakravarthi <ranga_at_shell.one.net>
Date: 1997/03/16
Message-ID: <5gfvvl$l5g@news.one.net>#1/1

sanjay rallapally (c696346_at_showme.missouri.edu) wrote:
: hi!
: a rookie question. I need to show image files (stored in .gif format) on
: the web. each image relates to a unique key.
: question: can i store the images in a table, so that the files can be
: displayed based on the key value ? i know that one of the dev. 2000 sample
: apps. has image files, but they never said how they got it in the table in
: the first place. I am using WOW(Web-Oracle-Web, the father of oracle web
: server ).
: Will appreciate any help,
:
:
: Sanjay Rallapally
: c696346_at_showme.missouri.edu
:

Yes, you can store an image (any format, gif, jpeg, bmp, etc) in a table with RAW/LONG RAW data types. (Any binary data can be stored as RAW).

If you have the following table structure :

EMPNO		NUMBER(6)
EMP_IMG		RAW;

Then, you can have an image of the employee and you can select the image using the empno.

Hope this helps,

• Ranga

  ---

life, n.:

        That brief interlude between nothingness and eternity.

---

Ranga Chakravarthi                                         e-mail: ranga_at_one.net
--------------------------------------------------------------------------------

Received on Sun Mar 16 1997 - 00:00:00 CST