you can try the following. not sure if it will work but it's definitely
worth a shot.
create a sequence (say MySeq) and add the sequence to the select statement.
for example,
select MySeq.nextval, .... from table;
the sequence must be reinitialized to 1 before any new query so it's more
like..
drop sequence MySeq;
create sequence MySeq start with 1 increment by 1;
select MySeq.nextval, .... from table;
this is a proposed solution for oracle. may/may not work with other
databases.
let me know if it works.
Received on Sun Jun 21 1998 - 00:00:00 CEST