Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Correlated updates.
I must have been having a bad day.
No sooner had I posted this,
I typed the answer into sql*plus...
update tableA
set ref = (select newref from tableB
where oldref = tableA.ref );
Thank's in advance for repies.
Back to putting up the Christmas decorations :-)
Mark Hunter
http://www.se7en.demon.co.uk
Received on Sun Dec 07 1997 - 00:00:00 CST