Cursor attributes used in PL/SQL
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.
Related posts:
- Difference between implicit & explicit cursor Differentiate between implicit & explicit cursor. only one row....
- Cursor attributes What are cursor attributes? -%ROWCOUNT -%NOTFOUND -%FOUND -%ISOPEN...
- Attributes of cursor What are attributes of cursor? %FOUND , %NOTFOUND...
- Type of Cursors Explain the two type of Cursors. There are...
- Why Cursor is required What is a cursor ? Why Cursor is required...
Related posts brought to you by Yet Another Related Posts Plugin.