Database Reference
In-Depth Information
8.1.2 SQL*Plus
SQL*Plus is an interactive program that allows you to type in and execute SQL statements.
It also enables you to type in PL/SQL code and send it to the server to be executed.
SQL*Plus is one of the most common front ends used to develop and create stored PL/SQL
procedures and functions.
What happens when you run SQL*Plus and type in a SQL statement? Where does the pro-
cessing take place? What exactly does SQL*Plus do, and what does the database do? If you
are in a Windows environment and you have a database server somewhere on the network,
the following things happen:
1. SQL*Plus transmits your SQL query over the network to the database server.
2. SQL*Plus waits for a reply from the database server.
3. The database server executes the query and transmits the results back to SQL*Plus.
4. SQL*Plus displays the query results on your computer screen.
The important thing is that SQL*Plus does not execute your SQL queries. SQL*Plus also
does not execute your PL/SQL code. SQL*Plus simply serves as your window into the
Oracle database, which is where the real action takes place.
Search WWH ::




Custom Search