This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes what is real world uses of cursors? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "what is real world uses of cursors?" Watch "what is real world uses of cursors?" New topic
Author

what is real world uses of cursors?

raminaa niilian
Ranch Hand

Joined: Jul 14, 2005
Posts: 551
Hi
Thank you for reading my post
What is real use of cursors, why we shuould have cursor in a select statement when we can return the rows without using cursors?

Thanks
Remko Strating
Ranch Hand

Joined: Dec 28, 2006
Posts: 893
With a cursor you can step through and process the rows in a ResultSet one by one.



In this not working code example you can process the Resultset with the help of a cursor one by one.


Remko (My website)
SCJP 1.5, SCWCD 1.4, SCDJWS 1.4, SCBCD 1.5, ITIL(Manager), Prince2(Practitioner), Reading/ gaining experience for SCEA,
raminaa niilian
Ranch Hand

Joined: Jul 14, 2005
Posts: 551
So when we are iterating over a resultset we are using a cursor, but it is implecit, that was something which i did not know.

Thanks
 
wood burning stoves
 
subject: what is real world uses of cursors?
 
Similar Threads
JDBC Max number of cursors exceeded issue
Open Cursor Exceeded in Oracle
maximumm cursors exceeded
What is Special about this Book
JDBC Level 4