Re: Update several columns

From: Thomas Kellerer <TAAXADSCBIXW_at_spammotel.com>
Date: Thu, 19 Oct 2006 09:25:00 +0200
Message-ID: <4ponicFjjvn5U1@individual.net>

On 19.10.2006 09:21 RanLi wrote:
> Hi,
> is it possible to update more than one column in the same statement
> without using a subselect?
>
>
> UPDATE <table>
> SET (COLUMN_1, COLUMN_2) = (SOME_VALUE,
> SOME_OTHER_VALUE)
> WHERE <something> = <something>
>
>
> or do we need to use two statements?
> Mabye the performance is ok even with two statements???

UPDATE table

SET col1 = 'value1',

col2 = 'value2'
WHERE .... For details see the manual:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_108a.htm#2067717 Received on Thu Oct 19 2006 - 02:25:00 CDT