May 01, 2005
Processing Rows in Batches
SELECT X, Y, Z FROM (SELECT X, Y, Z FROM SOMETABLE ORDER BY X) TEMPVIEW WHERE ROWNUM <= 100;
Example 1: Batches via ORDER BY and ROWNUM.
Previous Page |
1
|
2
|
3
|
4
|
5
Next Page
|
 |
|
|||||||||||||||||||||||||||
|
