Chapter 3. Working with the SQL Worksheet

The SQL Worksheet provides a scratch pad for all SQL, PL/SQL, and SQL*Plus statements and commands. You can run individual statements or a collection of commands. You can also run scripts and execute PL/SQL. In essence, doing all you might do in a command-line interface like SQL*Plus. The SQL Worksheet provides more, in that it offers code templates, provides code snippets, assists with code insight and completion, and maintains a history of commands. In this chapter, we look at these and other features offered in the SQL Worksheet and how to use them. We will use SQL and SQL*Plus commands to illustrate features, using PL/SQL only where needed specifically for a feature. All aspects of PL/SQL are addressed in the chapter on Working with PL/SQL.