Thread: How to read block of rows from database tables
View Single Post
  #1 (permalink)  
Old 07-27-2007, 02:58 PM
lmenaria lmenaria is offline
Member
  
Join Date: Jul 2007
Posts: 1
lmenaria is on a distinguished road
How to read block of rows from database tables
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
Laxmilal
Reply With Quote
Sponsored Links