Re: rownum

This is expected behavior of the rownum psuedo column going as far back as I can remember. I do not know where you find this specific fact in the manuals. In the SQL manual section on pseudo columns where it convers rownum the manual tells you that any > rownum condition returns FALSE and shows examples using less than, <, but it does not mention the fact you can only query for = 1.

The following is from the pl/sql manual (9.2)
>> The value of ROWNUM increases only when a row is retrieved, so the
only meaningful uses of ROWNUM in a WHERE clause are ... WHERE ROWNUM < constant;
... WHERE ROWNUM <= constant;
<<

HTH -- Mark D Powell -- Received on Mon Jan 03 2005 - 19:06:51 CST