Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |