Re: Re: "Oracle's ROWNUM"

Nicolas Ronayette <nronayette(at)alphacsp(dot)com> writes:
> SQL> select rownum,table_name from dba_tables where rownum > 10;

> no rows selected

> SQL> select rownum,table_name from dba_tables where rownum < 20;

> ROWNUM TABLE_NAME
> ---------- ------------------------------
> 1 IND$
> 2 FILE$
> 3 UNDO$
> 4 CLU$
> 5 BOOTSTRAP$
> 6 ICOL$
> 7 FET$
> 8 CDEF$
> 9 CON$
> 10 UET$
> 11 TAB$

> ROWNUM TABLE_NAME
> ---------- ------------------------------
> 12 OBJ$
> 13 PROXY$
> 14 COL$
> 15 USER$
> 16 TS$
> 17 CCOL$
> 18 SEG$
> 19 UGROUP$

> 19 rows selected.

(Jaw drops...) That's just too bizarre for words.

I don't think I wanna have anything to do with this construct ...

regards, tom lane