Re: Update question

"Phil Kaufman" <philk_at_dbcsmartsoftware.com> wrote in news:k1sza.219$hk1.67908696_at_mantis.golden.net:

> Hi everyone,
>
> This is for Oracle 8.0.5 (and above possibly).
>
> When I attempt to write an update statement with the following syntax:
>
> UPDATE <some table>
> SET <some column> = (SELECT 1 FROM DUAL) +
> (SELECT 2 FROM DUAL)
> /
>
> I get an error:
>
> SET number_of_batches = (SELECT 1 FROM DUAL) +
> *
> ERROR at line 2:
> ORA-00933: SQL command not properly ended
>
> My question: How to have a single update contain two sub-select? I
> tried the idea of:
>
> UPDATE <some table>
> SET <some column> = (SELECT tab1.col1 + tab2.col1
> FROM (SELECT 1 AS col1 FROM DUAL tab1),
> (SELECT 2 AS col1 FROM DUAL tab2)
> /
>
> but, no good, same error.
>
> Anyone have any ideas?
>
> Thanks very much in advance.
>
> Phil
>
>

Try adding some extra parens around the subquery:

UPDATE <some table>

    SET <some column> = ((SELECT tab1.col1 + tab2.col1

                             FROM (SELECT 1 AS col1 FROM DUAL tab1),
                            (SELECT 2 AS col1 FROM DUAL tab2))

Dan. Received on Fri May 23 2003 - 12:03:53 CDT