SQL Web Application Interface

The SQL*Plus web application interface provides you with some nice query-by-example (QBE) and SQL wizards to develop your applications. These tools are nice for both novice and experienced developers. They do, however, have some keen limitations that you will encounter as you use them.

This section will demonstrate how you use the web application interface to create a user, upload SQL scripts to the server, and run your uploaded SQL scripts in your user account. The upload utility stores your scripts inside the database as character large objects (CLOBs). They become a code repository that you can edit and update. When you run scripts from your repository, you read them from the database source and dynamically execute them in a SQL*Plus session.