Update several columns

From: RanLi <gladpike_at_hotmail.com>
Date: 19 Oct 2006 00:21:16 -0700
Message-ID: <1161242475.952295.52850@i3g2000cwc.googlegroups.com>

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???

tanks :)
ranli

---

Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production PL/SQL Release 9.2.0.5.0 - Production
CORE 9.2.0.6.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.5.0 - Production NLSRTL Version 9.2.0.5.0 - Production Received on Thu Oct 19 2006 - 02:21:16 CDT