Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Proper syntax for select *, rownum

Proper syntax for select *, rownum

From: Jake <me_at_heyjay.com>
Date: Wed, 6 Aug 2003 07:56:07 -0500
Message-ID: <bgqttu$lbg$1@bob.news.rcn.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US