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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Display numbering

Re: Display numbering

From: Kean Jacinta <jacintakean_at_yahoo.com>
Date: Mon, 16 May 2005 03:07:51 -0700 (PDT)
Message-ID: <20050516100751.9314.qmail@web52901.mail.yahoo.com>


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
> >
>
>
> --
>



> 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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 16 2005 - 06:12:27 CDT

Original text of this message

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