Oracle
1Z0-071 · Question #350
Which two statements are true about substitution variables? (Choose two.)
The correct answer is B. A substitution variable used to prompt for a column name must be enclosed in a single quotation C. A substitution variable prefixed with & always prompts only once for a value in a session. https://blogs.oracle.com/opal/sqlplus-101-substitution-variables
Retrieving Data Using the SQL SELECT Statement
Question
Which two statements are true about substitution variables? (Choose two.)
Options
- AA substitution variable can be used with any clause in a SELECT statement
- BA substitution variable used to prompt for a column name must be enclosed in a single quotation
- CA substitution variable prefixed with & always prompts only once for a value in a session
- DA substitution variable can be used only in a SELECT statement
- EA substitution variable used to prompt for a column name must be enclosed in double quotation
- FA substitution variable prefixed with && prompts only once for a value in a session unless it is set
How the community answered
(21 responses)- A5% (1)
- B81% (17)
- E10% (2)
- F5% (1)
Explanation
https://blogs.oracle.com/opal/sqlplus-101-substitution-variables
Topics
#substitution variables#SQL*Plus#& variable#&& variable
Community Discussion
No community discussion yet for this question.