Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> giving tuples a number to make them unique..

giving tuples a number to make them unique..

From: Jan Rosinowski <rosinowski_at_gmx.de>
Date: Thu, 14 Jan 1999 15:29:46 GMT
Message-ID: <369e0837.88294881@bigXb>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US