Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to convert Sybase update to suite Oracle ???
vipra wrote on 01.07.2005 20:16:
> Hi, what is the equivalent oracle DML for the below mentioned sybase one,
>
> update Table1
> set a.column3 = b.value3,
> a.column4 = b.value4,
> a.column5 = b.value5,
> a.column6 = b.value6
> from Table1 a,
> Table2 b
> where a.column1 = b.column1
> and a.column2 = 1
> and b.column2 > '28-APR-05'
> and b.column2 < '01-MAY-05'
>
> Works fine in Sybase but errors out in Oracle.
>
You can't have a FROM clause in an UPDATE. You will need to rewrite this with sub-selects
Thomas Received on Fri Jul 01 2005 - 16:34:13 CDT