December 2002
Intermediate to advanced
928 pages
85h 29m
English
A SQL iterator is used to process multiple rows returned from a SELECT statement. To use a SQL iterator, you must declare the iterator class, declare an iterator object, and then populate it with a SELECT statement. Once the iterator is populated, you can read rows from it. If you have a nested SELECT statement, you must use nested iterators to receive the data, one for each SELECT statement.
You can create an iterator and share it with a JDBC result set by assigning the result of getResultSet( ) to a JDBC result set.
There are two types of iterators: named iterators and positional iterators.