select...limit in oracle??..JDBC

Hi!

How can I perform :
SELECT * FROM TABLE WHERE ... LIMIT offset, rows in oracle....any help will be greatly appreciated!!!

or is there a better way to accomplish this via JDBC....

I am looking to have a jsp page where I load 10 records at a time with a

next and previous button that will get the prevoius or next 10 records....

thx
lance Received on Sun Apr 01 2001 - 09:44:26 CDT