Newbie : Retrieving rows by "packet" with ORACLE

Hi all,

I am new in Oracle DB. I used to use MySQL as DB so far. My problem is simple :
I would like to retrieve 10 lines from a table (not random lines, sorted by date).

With mySQL the query was like that :

select * from TABLE order by my_date limit 0, 10;

-> Returns the first 10 lines

select * from TABLE order by my_date limit 10, 10;

-> Returns the line 10 to 20

etc....

How can I do that in ORACLE ????

Thanks a lot for any help...

Best Regards.

JFR. Received on Fri Mar 31 2000 - 08:35:07 CST