Chapter 11

Multiple Commands, START Files, and Reports in SQLPLUS

It is sometimes prudent to create a set of commands that we would like to execute as one. In programming languages, we usually do this by creating a procedure or module. In SQLPLUS, this “command set” can be created in several ways. There are two general paths:

image We can write a script that is run with a START command.

image We can write a procedure or function that is compiled and used appropriately.

In this chapter, we will discuss the first general path — writing a script that is run ...

Get Practical Guide to using SQL in Oracle now with the O’Reilly learning platform.

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