Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Update table with contents from another table
> Update (Select T_A.C1, T_A.C2 ..., T_B.C2, T_B.C3
> FROM T_A, T_B
> WHERE ...)
> SET T_A.C1=T_B.C2,
> T_A.C2 = T_B.C3, ...
Very likely you've done a good choice.
Igor Received on Thu Jul 08 2004 - 15:34:06 CDT
![]() |
![]() |