Display numbering

  • From: Kean Jacinta <jacintakean@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 16 May 2005 02:14:52 -0700 (PDT)

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

Other related posts: