| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Any help appreciated, UPDATING
please reply to ngari_at_unbc.ca
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;
Received on Wed Jun 23 1999 - 23:04:11 CDT
 |
 |