Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sqlplus question ??
Yes you can, as long as the number itself is not important and does not need to
be 'repeatable' since it will change with any new select statement and will be
affected ( in so far as the rest of the column's contents are concerned ) by any
sort action - in other words, then number will not be related, in any way, to
the contents of the other fields..
"Neil C" <btsscrth_at_bt.com> wrote:
>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.
>>
>>
>
-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---------- http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Mon Oct 25 1999 - 09:51:03 CDT