🎴 Flashcard Mode

SQL and PL/SQL Database Concepts

Card1 / 20
Mastered0
Review0
QuestionClick to flip

Explicit Cursor attributes

AnswerClick to flip back
A
%Found
B
%NOTFOUND
C
%ROWCOUNT
D
%ISOPEN
💡 Explanation:

All four are valid explicit cursor attributes in PL/SQL. %FOUND returns TRUE if the last fetch returned a row. %NOTFOUND is the opposite. %ROWCOUNT counts rows fetched so far. %ISOPEN indicates whether the cursor is currently open. These attributes are essential for controlling cursor-based processing.

Change Mode