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

[487 byte] By [lmenariaa] at [2007-11-27 11:55:48]