Re: Re: "Oracle's ROWNUM"

Nicolas Ronayette <nronayette@alphacsp.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