How to "number" the retrieved rows

From: Helmut Daiminger <hdaiminger_at_vivonet.com>
Date: Tue, 29 May 2001 13:12:40 -0700
Message-ID: <F001.00312ABC.20010529132338@fatcity.com>

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). Received on Tue May 29 2001 - 15:12:40 CDT