Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Magazine Blooper
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
![]() |
![]() |