Iterating through SQL table
Posted by:
K R
Date: April 18, 2009 01:10PM
Hallo,
I have a presumably primitive Problem.
I have a really big table and I have to search in it. I'm sending queries via Java and then work with the result set. Now when I send a query the result set is so big, that I get java heap overflow. Is there any possibility to deal with such things. Does SQL have any kind of lineID so that I could iterate through the table. If there is no other possibility to solve the problem I have to insert one new column into the table, containing a lineID, which doesn't make me happy, as it will make the table larger again.
Thanks for your help
Subject
Written By
Posted
Iterating through SQL table
April 18, 2009 01:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.