Sqlplus question ??

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 - 08:52:26 CDT