Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to update multiple rows using UPDATE
Hi Bhagavan,
If I understand you correctly the answer is:
UPDATE emp
SET job = 'Manager',
sal = sal + 1000,
deptno = 20
WHERE ename = 'Jones';
regards
jerry gitomer
bkrishnaiyer_at_refco.com wrote in message
<7rbo99$sgj$1_at_nnrp1.deja.com>...
>Usually one can update single row using UPDATE command in oracle
when
>using WHERE clause. I want to know if we can update multiple
columns.
>
>Ex: I want to set col1 value of table1 with col1 values of
table2.
>
>Can somebody please tell me how to do this ?
>
>Thanks,
>Bhagavan.
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Mon Sep 13 1999 - 13:26:30 CDT
![]() |
![]() |