Re: Oracle Magazine Blooper

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 12 May 2004 07:48:40 +1000
Message-ID: <40a14a2c$0$442$afc38c87@news.optusnet.com.au>

Ed prochak wrote:

> No that's not better. It uses the dreaded ROWNUM! IMHO, ROWNUM is an
> abomination, unfit for use in any relational DBMS.
>
>
> Can you tell I do not like ROWNUM? Why? It gets beginners thinking
> there is some order to rows in a table when there really isn't.

I sympathise, but think that's a bit harsh. The first time a beginner tries 'select * from table where rownum > 1000' they begin to realise something isn't quite right. When 'select * from table where rownum = 1000' doesn't work either, they generally seem to get the point.

Regards
HJR Received on Tue May 11 2004 - 16:48:40 CDT