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:
We can write a script that is run with a START command.
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 ...