Problem while Retrieving of millions of records from ResultSet

[suresh chinnaswamy]

I'm executing a db query which returns a huge amount of data and writing the data in to a text file. Instead of iterating millions of times through the ResultSet and copying everything one-by-one, is there some way to simply retrieve data and write the result set data in to a file stream object.

Please suggest some solutions to overcome this isuue...