Oracle9i™ Development by Example

Using PL/SQL Pages

For developers familiar with PL/SQL, adding PL/SQL to existing HTML pages is possibly the quickest way to create great looking Web pages that are integrated with the database. You can use your in-house graphics department to create the look and feel of the Web pages required and then use PL/SQL to integrate the HTML Web pages with the Oracle9i database (creating PL/SQL Pages or PSP).

For example, standard HTML generators can create Web pages that look like page1.html (see Figure 11.3) and page2.html (see Figure 11.4). These are just base Web pages without any database interaction.

Figure 11.3. Basic Web page to be used to display autos.

Figure 11.4. Basic Web page to be used to buy autos.

The previous pages can be easily created ...