Oracle
1Z0-082 · Question #135
Which two statements are true about substitution variables?
The correct answer is B. A substitution variable prefixed with to prompts only once for a value in a session unless it is set to. See the full explanation below for the reasoning.
SQL and PL/SQL
Question
Which two statements are true about substitution variables?
Options
- AA substitution variable prefixed with & always prompts only once for a value in a session.
- BA substitution variable prefixed with to prompts only once for a value in a session unless it is set to
- CA substitution variable can be used only in a select statement.
- DA substitution variable used to prompt for a column name must be enclosed in single quotation
- EA substitution variable can be used with any clause in a select statement.
- FA substitution variable used to prompt for a column name must be enclosed in double quotation
How the community answered
(62 responses)- A2% (1)
- B73% (45)
- D8% (5)
- E15% (9)
- F3% (2)
Topics
#substitution variables#& operator#&& operator#SQL*Plus scripting
Community Discussion
No community discussion yet for this question.