2 Replies Latest reply on Dec 19, 2018 10:30 AM by John_K

    UPDATE COMMAND ON MULTIPLE TABLE error  ORA-00971: missing SET keyword

    1973864

      I have designed query , take which taking data from multiple tables and want to share update in one query. I am receiving error on the execution of code. Please correct query

       

      Error is ORA-00971: missing SET keyword

       

      UPDATE

      APPS.PN_PROPERTIES_ALL P,   --- Table

      APPS.PN_LOCATIONS_ALL L,   --- Table

      APPS.EM_PN_PROPERTY_ATTRIBUTES A,   --- Table

      APPS.HR_ALL_ORGANIZATION_UNITS OU  --- Table

       

       

       

      SET L.FLOOR = 'CVR-ST 01'

      SET A.UNIT_MODEL = 'CVR-ST-01'

       

       

       

       

      WHERE

       

          P.PROPERTY_ID = A.PROPERTY_ID

      AND L.LOCATION_ID = A.LOCATION_ID

      AND P.ORG_ID = OU.ORGANIZATION_ID

      AND P.ORG_ID = L.ORG_ID

      AND L.ORG_ID = A.ORG_ID

      AND L.ORG_ID IN (102,121)

      AND L.LOCATION_TYPE_LOOKUP_CODE = 'OFFICE'

      AND L.BUILDING LIKE '%CVR%'

      AND L.FLOOR LIKE '%Plot%'

      AND A.UNIT_MODEL LIKE 'Plot-1'