Result Sets and Cursors
by, 03-09-2012 at 07:28 PM (810 Views)
Conditions of a query are satisfied by the result set. Result set is considered to be rows set. A result set can return no. of rows.
One user might obtain 1 row at one time. This functionality is supported by the cursor.
Pointer and cursor are same which are present in a file that consists of many rows of the result set. Rows track is maintained by the pointer, which are accessible by the program. All rows top to bottom access is supported by a cursor, in a result set. It can further be used for sake of iterative processing. Automatically, a cursor is made with result set.
New capabilities are added by earlier JDBC API for result cursor set which allows it to move backward or forward. It also permits it to move to one specific row, whose position is relative to other one.