Re: Display numbering
- From: Kean Jacinta <jacintakean@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 16 May 2005 03:07:51 -0700 (PDT)
Hi,
Really appreciate your help :) THank u
JK
--- Giovanni Cuccu <giovanni.cuccu@xxxxxxxxx> 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@xxxxxxxxx>
> 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
> > --
> > //www.freelists.org/webpage/oracle-l
> >
>
>
> --
>
--------------------------------------------------------------------
> Another free oracle resource profiler
> http://sourceforge.net/projects/oraresprof/
>
__________________________________
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
http://mobile.yahoo.com/learn/mail
--
//www.freelists.org/webpage/oracle-l
Other related posts:
