Oracle PL-SQL Question:
Download Questions PDF

What are the cursor attributes used in PL/SQL?

Answers:

Answer #1
%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.

Answer #2
Found, notfound, isopen, rowcount

Download Oracle PL-SQL Interview Questions And Answers PDF

Previous QuestionNext Question
What is a cursor for loop?What are the PL/SQL Statements used in cursor processing?