Q76 Which two statements are true about substitution variables?
- (A). A substitution variable prefixed with & always prompts only once for a value in a session.
- (B). A substitution variable prefixed with && to prompts only once for a value in a session unless it is set to undefined in the session
- (C). A substitution variable can be used only in a select statement.
- (D). A substitution variable used to prompt for a column name must be enclosed in single quotation marks.
- (E). A substitution variable can be used with any clause in a select statement.
- (F). A substitution variable used to prompt for a column name must be enclosed in double quotation marks.
Answer: B, E