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:
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 ...
Get Practical Guide to using SQL in Oracle now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.