oracle select statement

[Anon]

with MYSQL, you can write a statement as billow:

SELECT * FROM table_name
WHERE ......
ORDER BY ....
LIMIT 10,5;

but with ORACLE, how can I implement the function as above?

[Anon]

try using oracle rowid & rownum, like this:

    SELECT *
    FROM   tableX
    WHERE  rowid in (
       SELECT rowid FROM tableX
       WHERE rownum <= $x
      MINUS
       SELECT rowid FROM tableX
       WHERE rownum < $y)

see http://www.doag.de/mirror/frank/faqsql.htm#ROWXtoY