Which statement is true about the fetch statements in the PL/SQL code?

Examine the following PL/SQL code:

Which statement is true about the fetch statements in the PL/SQL code?

Examine the following PL/SQL code:

Which statement is true about the fetch statements in the PL/SQL code?

A.
Each fetch retrieves the first row and assigns values to the target variables.

B.
Each fetch retrieves the next consecutive row and assigns values to the target variables.

C.
They produce an error because you must close and reopen the cursor before each fetch -statement

D.
Only the first fetch retrieves the first row and assigns values to the target variables- the second
produces an error.

Explanation:



Leave a Reply 4

Your email address will not be published. Required fields are marked *


samkelo siyabonga ngubo

samkelo siyabonga ngubo

B