Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Proper syntax for select *, rownum
Hi,
I'm on 8.1.7/linux
I'm trying to do
select rownum, * from mytable;
What's the proper syntax??
Thanks Jake
ps when I do:
SQL> select rownum, * from mytable;
select rownum, * from mytable
*
ERROR at line 1:
ORA-00936: missing expression
or
SQL> select *, rownum from mytable;
select *, rownum from mytable
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
Received on Wed Aug 06 2003 - 07:56:07 CDT