update table a.fkid from table b.pkid
From: amwi <amwi_at_yahoo.com>
Date: Wed, 14 Jul 2004 16:49:06 GMT
Message-ID: <6udJc.98556$dP1.331930_at_newsc.telia.net>
I have tried to solve this on my own for a long time now, so i really need some help here...
Date: Wed, 14 Jul 2004 16:49:06 GMT
Message-ID: <6udJc.98556$dP1.331930_at_newsc.telia.net>
I have tried to solve this on my own for a long time now, so i really need some help here...
I use Oracle 10.1 and SQL *plus 10.1.
How do i update table a.fkid from table b.pkid with the following "rule". The table b.pkid's should be evenly distributed over table a as fkid's.
Does anyone have a tip on how to solve this?
Thank you. Received on Wed Jul 14 2004 - 18:49:06 CEST