SQL Language (MOSC)

MOSC Banner

I'am Unable to execute the update script error ORA-00971:missing SET keyword.Please let me know the

edited Sep 28, 2017 4:40PM in SQL Language (MOSC) 4 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center