Storing images in oracle 9i
-
Dear all, I'm trying to do a project on birds and saving information such as the scientific classification and naming. I want to save images of birds in the database so I can display them later in forms or reports when the user does a query about a bird. For some birds I have more than one image so I want to include all images. My question is how I can do that, I mean how can I store the images in oracle? I'm using Oracle 9i. So far I have created a table to store the birds and their classification and tried to google about storing the images but no luck yet :( Could you please help me with that.. I have a quite little background in oracle 9i :$ Thanks folks :)
-
Dear all, I'm trying to do a project on birds and saving information such as the scientific classification and naming. I want to save images of birds in the database so I can display them later in forms or reports when the user does a query about a bird. For some birds I have more than one image so I want to include all images. My question is how I can do that, I mean how can I store the images in oracle? I'm using Oracle 9i. So far I have created a table to store the birds and their classification and tried to google about storing the images but no luck yet :( Could you please help me with that.. I have a quite little background in oracle 9i :$ Thanks folks :)
noora-m wrote:
tried to google about storing the images but no luck
I do wonder what you used as the serch criteria, I find pleanty of info with the following
oracle 9i store imagesIf there are to be mode than 1 images per bird then you need a separate table for the images with a FK to the birds table. BirdsTable BirdID (PK) BirdName ImageTable ImageID (PK) BirdID (FK) BlobFieldNever underestimate the power of human stupidity RAH