Re: Sqlplus question ??

Why don't you temporarily create a sequence? Try this:

   CREATE SEQUENCE seq ......
   SELECT seq.nextval, col1, col2, ......    DROP SEQUENCE seq;

HTH,
Brian

Cliff Powell wrote:
>
> 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:30:58 CDT