Which /SQL*Plus feature can be used to replace values in the WHERE clause?

The correct answer is A. Substitution variables. Lexical substitution variables can be used to replace values in the WHERE clause. Incorrect Answers B: There are no replacement variables SQLPlus feature in Oracle. C: There is no prompt variables SQLPlus feature in Oracle. D: There is no instead-of variables SQLPlus feature in…

Basic SQL SELECT Statements

Question

Options

ASubstitution variables
BReplacement variables
CPrompt variables
DInstead-of variables
EThis feature cannot be implemented through /SQL*Plus.

How the community answered

(23 responses)

A
83% (19)
B
4% (1)
C
9% (2)
E
4% (1)

Explanation

Lexical substitution variables can be used to replace values in the WHERE clause. Incorrect Answers B: There are no replacement variables SQLPlus feature in Oracle. C: There is no prompt variables SQLPlus feature in Oracle. D: There is no instead-of variables SQLPlus feature in Oracle. E: This feature is implemented in the SQLPlus with lexical substitution variables.

Topics

#substitution variables#SQL*Plus#dynamic WHERE clause#runtime input

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice