Re: How to update multiple rows using UPDATE

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Mon, 13 Sep 1999 14:26:30 -0400
Message-ID: <7rjh83$mi8$1@winter.news.rcn.net>

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