rownum is a pseudocolumn; not useful for sequences.
Norris wrote in message <7p5rmm$75a$1_at_imsp009a.netvigator.com>...
>I want to use rownum as the sequence number in the report but the result
>is not what I expect. What can I do?
>
>------------------------------------------
>drop table abc
>/
>create table abc (a char(1))
>/
>insert into abc values ('B')
>/
>insert into abc values ('A')
>/
>select rownum,a
>from abc
>order by a
>/
>ROWNUM A
>---------- -
> 2 A
> 1 B
>2 rows selected.
>
>
>--
>--
>http://www.washington.edu/pine/faq/
Received on Mon Aug 16 1999 - 02:44:49 CDT
