Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Functions in Update
I have a query that uses a couple of custom-developed functions to
update two columns. The syntax I am using is as follows. Mytable has
col1, col2 and col3 and all are type number.
UPDATE mytable SET col2 = func1(col1), col3 = func2(col1, col2);
The thing is that when the query is executed, the col3 values are not updated as expected. That is, func2 uses the old values of col2 and not the newly computed values. Is there a way to resolve this?
This is on Oracle 9.2 on Windows XP. Received on Sat Feb 14 2004 - 00:09:21 CST