Which substitution variable would you use if you want to reuse the variable without prompting the
user each time?
A.
&
B.
ACCEPT
C.
PROMPT
D.
&&
Explanation:
To reuse the variable without prompting the user each time you can use && substitution variable.
Incorrect Answers
A:This substitution variable will prompt the user each time.
B:ACCEPT is command, not substitution variable. It used to define more accurate or specific
prompt or when you want more output to display as the values are defined.
C:PROMPT is part of the ACCEPT command, it is not a variable.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 165-173
Chapter 4: Sub queries