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 -> Re: Proper syntax for select *, rownum

Re: Proper syntax for select *, rownum

From: Jake <me_at_heyjay.com>
Date: Wed, 6 Aug 2003 09:46:35 -0500
Message-ID: <bgr4ct$7r2$1@bob.news.rcn.net>


Thanks Stephan

"Stephan Bressler" <agadir_at_web.de> wrote in message news:3F30FFC0.1060409_at_web.de...
>
>
> > select rownum, * from mytable;
> >
> > What's the proper syntax??
>
> select rownum, mytable.* from mytable
> or
> select rownum, myalias.* from mytable myalias
>
> Stephan
>
Received on Wed Aug 06 2003 - 09:46:35 CDT

Original text of this message

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