I'am Unable to execute the update script error ORA-00971:missing SET keyword.Please let me know the
Unable to execute the below update script
update APPS.WIP_EAM_WORK_REQUESTS A
JOIN APPS.wip_discrete_jobs B
ON (A.wip_entity_id = B.wip_entity_id)
SET A.WORK_REQUEST_STATUS_ID = 6
where A.wip_entity_id = B.wip_entity_id
and B.STATUS_TYPE = '12'
and A.WORK_REQUEST_STATUS_ID = '4'
AND B.ORGANIZATION_ID = '93'
AND TRUNC(A.CREATION_DATE) BETWEEN '20-DEC-2016' AND '30-DEC-2016' ;
error message := ORA-00971:missing SET keyword
Please let me know the reason