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.
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
Authors: Jonathan Gennick
Simiral book on Amazon