Re: How to "number" the retrieved rows

select rownum,column1, column2 from tablename

Rownum is the counter of the returned rows. The first row will return 1, the second 2, etc...

Rownum is only valid for the select and there is no guaranteed that the same rownum will be attached to the same row in the future.

>>> hdaiminger_at_vivonet.com 05/29/01 05:23PM >>>
Hi!

Is there a way to show a number in front of every row retrieved through a select statement...?

select column1, column2 from tablename

The output should look like:

1 column1_value column2_value

Any idea how I can achieve that?

This is 8.1.6 on Win2k.

Thanks,
Helmut

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Helmut Daiminger
  INET: hdaiminger_at_vivonet.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: BeilstWH_at_obg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).