SQL*Plus User's Guide and Reference

CHAPTER 3. Manipulating Commands

This chapter helps you learn to manipulate SQL*Plus commands, SQL commands, and PL/SQL blocks. It covers the following topics:

editing a SQL*Plus command

using SQL*Plus commands to list and modify the command currently stored in the buffer

editing commands with a system editor

creating and modifying command files to hold commands for later use

retrieving and running command files

saving SQL*Plus environment settings

writing interactive commands that include user variables and substitution variables

passing parameters to a command file

using bind variables and REFCURSOR variables

tracing SQL statements

Read this chapter while sitting at your computer and try out the examples shown. Before beginning, make sure you have access to the sample tables described