Try an inline view:
SELECT * FROM
(SELECT rownum rnm , t.*
FROM table t)
WHERE rnm >= &&part * 10
AND rnm < (&&part + 1 ) * 10
|
Results 1 to 7 of 7
Thread: n records at a timeThreaded View
|
Click Here to Expand Forum to Full Width |