Hi all, i need help. that i run a select query from my data base, which return millions of records from oracle. The application give a retrieval error (after a long time) of over flow. What should i do to implement paging and get only few data at a time. (rownum does not work because it select query has to perform some addition operations too) i m using myeclipse ide i am new bee, so please help me detailed.
-- Regards, Jahan Zaib