Writing SQL*Plus Scripts

In the previous chapter, you saw how to write a script to produce a report. This chapter delves more deeply into the subject of scripting, and shows you how to write interactive scripts. You will learn how to use substitution variables , which allow you to supply values dynamically to a script at runtime. You will learn how to prompt the user for those values and how to display other messages for the user to see. Finally, you will learn how to package your script for easy access when you need it.