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