Oracle
1Z0-144 · Question #123
Within a PL/SQL loop, you need to test if the current fetch was successful. Which SQL cursor attribute would you use to accomplish this task?
The correct answer is C. SQL%FOUND. See the full explanation below for the reasoning.
Question
Within a PL/SQL loop, you need to test if the current fetch was successful. Which SQL cursor attribute would you use to accomplish this task?
Options
- ASQL%ISOPEN
- BSQL%ROWCOUNT
- CSQL%FOUND
- DThis task cannot be accomplished with a SQL cursor attribute.
- EA SQL cursor attribute cannot be used within a PL/SQL loop.
How the community answered
(33 responses)- A3% (1)
- C79% (26)
- D6% (2)
- E12% (4)
Community Discussion
No community discussion yet for this question.