Which two statements are true about substitution variables? (Choose two.)

Question

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 marks
• 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 marks
• FA substitution variable prefixed with && prompts only once for a value in a session unless it is set to

• A
  3% (1)
• B
  80% (24)
• D
  13% (4)
• F
  3% (1)

Explanation

Explanation/Reference: https://blogs.oracle.com/opal/sqlplus-101-substitution-variables

No community discussion yet for this question.