Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Query...
hi,
i have table with users and email-address. There can be multiple
email-address for a user and there can be multipe users having same
email-address.
eg: Table T1:
u1,e1 u2,e2 u2,e3 u3,e3 u3,e5 u4,e2 u5,e1 u6,e4
I need to build a table having users,email-addres and key. All users having same email address should have same key and all email address of these users should also have this same key. These email address may be shared by other users. they also should have the same key..This repeats..
The resultant table should be like the below...
u1,e1,k1 u2,e2,k2 u2,e3,k2 u3,e3,k2 u3,e5,k2 u4,e2,k2 u5,e1,k1 u6,e4,k3
Thanks in advance... Received on Mon Jul 02 2007 - 22:54:14 CDT
![]() |
![]() |