Re: Why I too don't like the OCP

That's pretty much what I said. Although, to be nitpicky, rownum = 1, at the time when the check is done in the WHERE clause, has nothing yet to do with "the results," as there are no "results" until AFTER the row is selected... and even then rownum (the counter, which is what's used in the WHERE clause) doesn't reflect results, as it's always incremented +1 ahead of the resultset.

In article <83b4e845.0205091058.7c0e9cdb_at_posting.google.com>, eramoshdez_at_hotmail.com (Eduardo) wrote:
>Jeff,
>
>I loved your answer. It is funny. Now the serious answer is that
>rownum between 10 and 20 is always gonna return nothing since rownum =
>1 is the first row of... the results. It's like wanting a building
>starts in the 10th floor.

>jeff_at_work.com (Jeff) wrote in message

>> beginning of a query, rownum (the column) is both valueless and meaningless
>> and cannot be used this way in the WHERE clause of a query. There will never
>> be a case where rownum (the counter) satisfies the above WHERE clause, since
>> it MUST start with 1, so setting a lower boundary is pointless. Therefore,
Received on Mon May 13 2002 - 07:46:14 CDT