Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Display numbering
Hi,
Really appreciate your help :) THank u
JK
--- Giovanni Cuccu <giovanni.cuccu_at_gmail.com> wrote:
> Hi,
> what about rownum?
>
> select rownum,name,description from your_table
>
> Giovanni
>
> P.S. beware of order by and rownum together in that
> case the query should be
> select rownum,name,description from
> (select name,description from your_table order by
> description)
>
> On 5/16/05, Kean Jacinta <jacintakean_at_yahoo.com>
> wrote:
> > Hi,
> >
> > Would it be possible to generate numbering in
> simple
> > select statement ?
> >
> > For example :
> >
> > No Name Descripton
> > 1 APPLE FRUITS
> > 2 ORANGE FRUITS
> > 3 PINE FRUITS
> > 4 MELONG FRUITS
> >
> > The "No column" is not stored in the database. It
> > just dispay the number for better viewing
> purposes.
> >
> > Thank YOU
> >
> > JK
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
>
>
> --
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 16 2005 - 06:12:27 CDT