🎴 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.