Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

1973864Dec 19 2018 — edited Dec 19 2018

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.

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'

Comments
Post Details
Added on Dec 19 2018
4 comments
515 views