| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> update multiple columns in pl/sql
To all:
Is there a better way to code the following statement ?
A= a*b; B= a*b*c; A,B,C are calculated values. C=b*c;
update tab set (col1,col2,col3) =(select A,B,C from dual);
Thanks in advance, Ted Chyn Received on Sat Dec 13 1997 - 00:00:00 CST
![]() |
![]() |