>
> row#, field1
> 1, a
> 2, b
> 3, c
> 4, d
> ... and so on
>
> Regards,
>
> Fabiano.
>

create generator gen_row_01;

select gen_id(gen_row_01, 1), field1 from table1;

drop generator gen_row_01;

Tom