giving tuples a number to make them unique..

i need to number rows in a _select_-statement to get unique tuples with ascending instanceids:

name,	instanceid
a,	1 
a,	2
b,	1
c,	1
c,	2
c,	3
d,	3

(the select-statement is a flattened inclusion-hierarchy using connect-by which is intended to be inserted in another relation)

any ideas?

if that's not possible: how can i get a sequence on the fly? in sybase one uses number(*) for that purpose..

ciao, jan Received on Thu Jan 14 1999 - 09:29:46 CST