• Post Reply Bookmark Topic Watch Topic
  • New Topic

collection

 
thri nath
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
how can we store the data of one record into collection and retrieve from that
 
Subhadip Chatterjee
Ranch Hand
Posts: 93
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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, resultset.next() 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.
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!