Oracle
1Z0-061 · Question #216
Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition?
The correct answer is C. SELECT &1, &2. In a WHERE clause, date and characters values must be enclosed within single quotation marks. Sample of the correct syntax SELECT EMPLOYEE_ID, &COLUMN_NAME
Retrieving Data using the SQL SELECT Statement
Question
Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition?
Options
- ASELECT &1, "&2"
- BSELECT &1, '&2'
- CSELECT &1, &2
- DSELECT &1, '&2'
How the community answered
(31 responses)- A6% (2)
- B10% (3)
- C81% (25)
- D3% (1)
Explanation
In a WHERE clause, date and characters values must be enclosed within single quotation marks. Sample of the correct syntax SELECT EMPLOYEE_ID, &COLUMN_NAME
Topics
#substitution variables#ampersand#user input#SELECT statement
Community Discussion
No community discussion yet for this question.