Translate syntax script from Ingres to Oracle

From: (wrong string) ål Jakobsen <paal.jak_at_nl.telia.no>
Date: Fri, 30 Apr 1999 07:51:40 +0200
Message-ID: <37294389.0_at_d2o207.telia.com>

Can anyone help me translate the following update script from Ingres to Oracle syntax ?

exec sql UPDATE table1 a

       FROM table2 p
SET requiredate = requiredate +

      date( varchar(ifnull(p.lt_offset,0)) + 'days'),     lastactivity = 'now'
      WHERE a.ordercd = '2'

AND a.orderno   = :order_no
AND a.parentpart   = :partno
AND a.partno = p.subpart
AND p.parentpart = a.parentpart ;

Thank you in advance ! Received on Fri Apr 30 1999 - 07:51:40 CEST