Hello to everybody!
I've searched for a long time to get a simple solution for the missing LIMIT X,Y in Oracle.
Finaly I've found this solution:
select * from (select rownum as ROW_ID, X, Y from DATABASE) where ROW_ID between MIN and MAX
rownum is a virtual column, which is automatically added by Oracle.
Don't despair on Oracle - It's not so slow, bad, crazy ...
Best wishes
Toni
I've searched for a long time to get a simple solution for the missing LIMIT X,Y in Oracle.
Finaly I've found this solution:
select * from (select rownum as ROW_ID, X, Y from DATABASE) where ROW_ID between MIN and MAX
rownum is a virtual column, which is automatically added by Oracle.
Don't despair on Oracle - It's not so slow, bad, crazy ...
Best wishes
Toni