9 Replies Latest reply on May 16, 2012 2:16 PM by Karthick2003

    Convert a SQL Server Update Statement for Oracle

    LilithSChild
      Hi,
      i need to convert an update statement written for SQL Server to make it work on Oracle,
      the update is the following:

      UPDATE     TABLE1
      SET     CDate = TBL2.CDate
      FROM      TABLE1 TBL1
                JOIN TABLE2 TBL2 ON TBL2.Code = TBL1.TBL2Code
                JOIN TABLE3 TBL3 ON TBL3.Id = TBL1.Id
      WHERE     TBL3.TypeCode = '07'

      how can i make it compatible with oracle?

      thanks!!