Sql*Plus User’s Guide and Reference

Exiting from a Script with a Return Code
........................................................................................ 5-11
Defining Substitution Variables
........................................................................................................ 5-11
Using Predefined Variables
................................................................................................................. 5-12
Using Substitution Variables
.............................................................................................................. 5-12
Where and How to Use Substitution Variables.......................................................................... 5-12
Avoiding Unnecessary Prompts for Values ................................................................................ 5-14
Restrictions ...................................................................................................................................... 5-17
System Variables ............................................................................................................................. 5-17
Passing Parameters through the START Command
....................................................................... 5-17
Communicating with the User
............................................................................................................ 5-19
Receiving a Substitution Variable Value .................................................................................... 5-19
Customizing Prompts for Substitution Variable ....................................................................... 5-20
Sending a Message and Accepting Return as Input .................................................................. 5-21
Clearing the Screen ......................................................................................................................... 5-21