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 Commands

• Saving Commands for Later Use

• Writing Interactive Commands

• Using Bind Variables

• Using REFCURSOR Bind Variables

• Tracing 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 in Chapter 1.