尝试在ORACLE中运行以下更新查询时ORA-00933

I have the below query which works fine when run in SQL Server. But the same is failing in Oracle db.I have the below query which works fine when ru