When you use a cursor in a procedure,the ____ command advances the cursor to the next row in the set of rows retrieved by the query and places the contents of the row in the indicated variables.
A)RETRIEVE
B)FETCH
C)GET
D)ADVANCE

Question

When you use a cursor in a procedure,the ____ command advances the cursor to the next row in the set of rows retrieved by the query and places the contents of the row in the indicated variables.
A)RETRIEVE
B)​FETCH
C)GET
D)​ADVANCE

Quizplus · Accepted Answer

The FETCH command is used to advance the cursor to the next row in the set of rows retrieved by the query and to place the contents of the row in the indicated variables. RETRIEVE, GET, and ADVANCE are not valid commands for moving the cursor in a SQL procedure.

When You Use a Cursor in a Procedure,the ____ Command