Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes JDBC and Relational Databases and the fly likes collection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "collection" Watch "collection" New topic


thri nath

Joined: Mar 13, 2007
Posts: 4
how can we store the data of one record into collection and retrieve from that
Subhadip Chatterjee
Ranch Hand

Joined: Dec 12, 2006
Posts: 93
Hi Nath,
Please be clear about your askance.Do you want each of the resultset records, as a whole, will be stored into Collection object? In that case, only moves block wise, as like in chessboard. It will complete traversing all columns in a row, and then move to the next row...resultset can't capture the row itself, unless you are writing the SQL query (obvoiusly, in a PL/SQL block) to return you a %ROWTYPE data, not the columns.

Refreshing life every moment...
I agree. Here's the link:
subject: collection
jQuery in Action, 3rd edition