Re: Sqlplus question ??

From: Neil C <btsscrth_at_bt.com>
Date: Mon, 25 Oct 1999 15:04:31 +0100
Message-ID: <7v1o19$n0g$1@pheidippides.axion.bt.co.uk>

Could you use rownum ? I.e select rownum, column1, column2, ....... from table

HTH NeilC

Cliff Powell wrote in message <7v1nkg$erj$1_at_ffx2nh3.news.uu.net>...
>I'm trying to select from a single table into a flat ascii file to send to
a
>customer. I need a sequential number for each row selected. For example,
>row 1 needs to have 00001 in a column, row 2 needs to have 00002, etc. How
>can I create a sequential number in this select ? I really don't want to
>add a sequence to the table, I just need a sequential number for each
record
>selected out into my flat file.
>
>Many thanks.
>
>
Received on Mon Oct 25 1999 - 09:04:31 CDT