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.
% 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 #2Found, notfound, isopen, rowcount
Download Oracle PL-SQL Interview Questions And Answers
PDF
Previous Question | Next Question |
What is a cursor for loop? | What are the PL/SQL Statements used in cursor processing? |