Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> UPDATING error
if you read the last post sorry for nto telling you that i am using
oracle 8
update (select * from defree where project=3 and version=2 and id=5) DT1
(select * from deftree where project=3 and version=2 and id=DT1.parent)
DT2
(select * from deftree where project=3 and version=2 and id=DT1.child)
DT3
SET DT2.child=DT1.child and DT3.parent=DT1.parent;
Please respond to ngari_at_unbc.ca Received on Wed Jun 23 1999 - 23:05:34 CDT