🎴 Flashcard Mode
Oracle Database Administration Comprehensive Practice Test
Card1 / 22
Mastered0
Review0
QuestionClick to flip
In this PL/SQL statement, which of the following lines will produce an error?
AnswerClick to flip back
A
into my_city, my_state
💡 Explanation:
The INTO clause must come after the SELECT statement's column list but before the FROM clause. The correct order in a cursor declaration is: CURSOR name IS SELECT column_list INTO variable_list FROM table WHERE condition. The 'into my_city, my_state' line is misplaced in the structure.