what is real world uses of cursors?

[raminaa niilian]

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]

With a cursor you can step through and process the rows in a ResultSet one by one.

   
while (rs.next) { 
    system.out.println(rs.getString(1)); 
 
} 

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

[raminaa niilian]

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