correction...

In 8.1.7 it works, it's sure we have recently upgraded from 8.0.5 ...
i suppose the correct query is

select ename, empno FROM

   (select empno, ename, rownum-1 R
    from emp
    order by empno) e
WHERE
   R between x*50 and (x+1)*50

x representing the required page. Received on Tue Jul 03 2001 - 23:49:07 CEST