Re: How to convert Sybase update to suite Oracle ???

vipra (gandrakota_at_mailcity.com) wrote:
: 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.

looks fine enough, but the dates should use to_date() to ensure the correct interpretation.

        (untested)

        to_date('28-APR-05','DD-MON-YY')

--

This space not for rent.