DEVFYI - Developer Resource - FYI

What are the cursor attributes used in PL/SQL ?

ORACLE Interview Questions and Answers (Part 3)


(Continued from previous question...)

501. What are the cursor attributes used in PL/SQL ?

%ISOPEN - to check whether cursor is open or not
% ROWCOUNT - number of rows fetched/updated/deleted.
% FOUND - to check whether cursor has fetched any row. True if rows are fetched.
% NOT FOUND - to check whether cursor has fetched any row. True if no rows are featched.
These attributes are proceeded with SQL for Implicit Cursors and with Cursor name for Explicit Cursors.

(Continued on next question...)

Other Interview Questions