1 Reply Latest reply on Feb 19, 2013 7:09 PM by orafad

    how to use multipule join in update stmt


      i have a query in mssql i want to translate it using oracle 11g r2 latest sysntex

      UPDATE trips
      SET locations = trips.city + ', ' + poi.city
      FROM trips INNER JOIN poi
      ON poi.trip_guid = trips.guid

      where trips.trip_guid =1

      UPDATE trips t
      SET locations = t.city + ', ' + p.city
      FROM poi p
      ON p.trip_guid = t.guid

      where t.trip_guid =1

      please tel me how i can write it in oracel 11g r2

      i also show there is mearge statmet is it sql or plsql

      yours sincerely

      Edited by: 944768 on Feb 19, 2013 4:20 AM