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 ...

Get Oracle9i™ Development by Example now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.