The SQL Editor
The SQL buffer is a work area assigned to the SQL*Plus environment. This buffer only contains SQL or PL/SQL syntax. The contents of this buffer can be loaded, saved, and manipulated with the following commands.
PL/SQL (pronounced P - L - S - Q - L) is an Oracle9i procedural language with SQL imbedded in it. This gives the user the ability to perform various tasks based on row-at-a-time or result set processing of the SQL. PL/SQL is useful for performing looping functions and in-depth calculations based on a variety of variables and other tables.
A or APPEND new text
Appends text to the end of the current line of the SQL buffer. In Figure 2.4, the L is used to show the current line in the SQL buffer as well as change the current ...