Data Warehousing Community Forum
October 24, 2019, 01:16:06 am

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

Reputation: +56/-0
Offline Offline

Posts: 354


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

advertisement
Whoever
Administrator
*****

Reputation: +55/-0
Offline Offline

Posts: 145



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

Wenn ist das Nunstück git und Slotermeyer? Ja! … Beiherhund das Oder die Flipperwaldt gersput.
Pages: [1]   Go Up
  Print  
Jump to: