December 2002
Intermediate to advanced
928 pages
85h 29m
English
Name of the variable that you want to define.
Specifies the type of data you are after.
Specifies a format specification, which may be optionally enclosed in quotes.
Provides a default value to assign to the variable.
Specifies the prompt text displayed to the user.
Indicates that you do not want the user to see a visible prompt.
Causes SQL*Plus not to echo the user’s response back to the display. This is useful if you are prompting for a password.