Figure 1: Nondeterministic row number query result
rownum qty orderid
1 10 30001
2 10 10001
3 10 10006
4 10 40005
5 15 30003
6 20 30004
7 20 20002
8 20 20001
9 30 10005
10 30 30007
11 40 40001