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