Multiple choice technology databases

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

  1. &

  2. accept

  3. prompt

  4. &&
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In SQL*Plus, a single ampersand & prompts the user for a value every time it is encountered. The double ampersand && defines a substitution variable that prompts the user only once and reuses that value throughout the session without prompting again.

Keep practicing — related questions