Which substitution variable would you use if you want t…

Which substitution variable would you use if you want to reuse the variable without prompting the user each
time?

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *