Data Warehousing Community Forum
February 08, 2012, 11:01:57 am

Pages: [1]   Go Down
  Print  
Author Topic: Cursor attributes in PL/SQL  (Read 1130 times)
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« on: June 28, 2007, 05:50:20 pm »


Hi All,

Let me know what are all the Cursor attributes used in PL/SQL?
Please define the function of each and every Cursor attribute?

Thanks...
Logged

Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« Reply #1 on: June 29, 2007, 02:44:14 pm »

The Cursor attributes are as follows -

%ISOPEN - To check whether cursor is open or not
%ROWCOUNT - Number of rows fetched/updated/detected
%FOUND - To check whether cursor has fetched any row. True is rows are fetched.
%NOTFOUND - To check whether cursor has fetched any row. True is rows are not fetched.

These attributes are proceeded with SQL for Implicit Cursors and with Cursor name for Explicit Cursors.
Logged

If most people said what’s on their minds, they’d be speechless.
Pages: [1]   Go Up
  Print  
 
Jump to: