Oracle9i™ Development by Example

Planning a Web Site—Buy a Car

As cars are prepared for sale, they are added to the ST_CARS_FOR_SALE table (see Figure 8.5). This object tracks the inventory ID, the description of the car, and the location of the picture image on disk. HTML output can pick up images from only the disk, so all you need to do is store the location of the image in the database, not necessarily the whole picture. If the picture is stored in the database, the get_lob PL/SQL built-in procedure can be used to extract it to a specific location with a specific name, which can then be referenced by the HTML output. An additional Oracle form could be added to maintain the ST_CARS_FOR_SALES, and of course, a report or form would be needed to display or process the BUYER ...