Re: Update question

From: pob <patrickobrian_at_excite.com>
Date: Fri, 23 May 2003 17:16:32 GMT
Message-ID: <1ba4dc879d690ddaff55135619ec3b2b@TeraNews>

Try again. I still have it wrong with the number of parens. Basically, enclose your entire subquery in a set of parens.

update <some table>

   set <some column> = (subquery)
/

so... try this (it works):

UPDATE <some table>

   SET <some column> = (

                        SELECT col1 + col2
                          FROM (SELECT 1 AS col1 FROM DUAL),
                               (SELECT 2 AS col2 FROM DUAL)
                       )

/

---

pob Received on Fri May 23 2003 - 12:16:32 CDT