|Lesson 6|| Other ways to integrate Oracle and the Internet|
|Objective||List other tools and features that help Oracle function well for Internet applications. |
Other ways to integrate Oracle and the Internet
We have only scraped the surface of all the tools available to you when you are developing Web-database applications.
The primary features (ones you should know for the Certification exam) have all been covered.
The table below lists some of the other tools and technologies you will very likely want to look over when you start combining your Oracle database with the Internet.
Click here to test yourself.
The next lesson wraps up the module.
WebDB is an Oracle product that is used to create Web sites and applications.
The core data for the sites and applications is stored in Oracle tables. When a client accesses the site, the client's request is handled by a Web listener, such as the Oracle Application Server (OAS).
The Web listener executes PL/SQL functions stored within the database. Those functions return the requested data embedded within HTML tags. The listener then returns that data to the client, and the site is displayed within the client's browser.
To display the WEATHER table in a client browser, you could create a WebDB application. The WEATHER table will reside within the database on the database server.
To display the data in tabular format, the query by the application server will embed HTML table formatting tags in the output. The result is an HTML file that contains the embedded HTML table formatting tags along with the data from the WEATHER table's rows.
WebDB is rapidly changing as new versions are introduced. You can presently use WebDB for a variety of purposes:
- Web site development
- Web application development
- Ad hoc querying of the data dictionary
- Ad hoc querying of application tables
- Database administration
You can use WebDB for many purposes, but you should consider your desired outcomes before implementing it. As WebDB requires a three-tier architecture, you need to make sure this architecture fits your environment and your processing capabilities.