I have created a Database Application in Java and display all the records in tabular format of one Table. This table have Millions of Rows, If I run Select * from Table, then my Machine not responding, so Now I wants to add paging of 1000 rows at one time.
Is there are any option to read block of rows at one time and then query again for next page ?
Please let me know..
Database : SQL Server 2000/2005, Oracle and MYSQL
Thanks in Advance