Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> How to convert Sybase update to suite Oracle ???
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. Received on Fri Jul 01 2005 - 13:16:09 CDT