update从另一个表 oracle,sql-update – 从另一个表更新多个列 – 需要Oracle格式

我有一个我在SQL Server中使用的脚本,但我需要将其转换为Oracle格式.有人可以帮忙吗？

UPDATE PERSONS P SET

P.JOBTITLE=TE.JOBTITLE,

P.LAST_NAME=TE.LAST_NAME,

P.FIRST_NAME=TE.FIRST_NAME,

P.DBLOGIN_ID=TE.DBLOGIN_ID,

P.EMAIL_ID=TE.EMAIL_ID,

P.USERLEVEL=TE.USERLEVEL,

P.FACILITY_ID=TE.FACILITY_ID,

P.SUPERVISOR=TE.SUPERVISOR,

P.DEPARTMENT=TE.DEPARTMENT,

P.WINLOGINID=TE.WINLOGINID

FROM TEMP_ECOLAB_PERSONS TE

WHERE P.PERSON=TE.PERSON;

– 从下面的文章中我得出以下声明.不幸的是,它仍然不起作用：

UPDATE (SELECT P.JOBTITLE, P.LAST_NAME, P.FIRST_NAME, P.DBLOGIN_ID, P.EMAIL_ID,

P.USERLEVEL, P.FACILITY_ID, P.SUPERVISOR, P.DEPARTMENT,

TE.JOBTITLE, TE.LAST_NAME, TE.FIRST_NAME, TE.DBLOGIN_ID, TE.EMAIL_ID,

TE.USERLEVEL, TE.FACILITY_ID, TE.SUPERVISOR, TE.DEPARTMENT

FROM PERSONS P, TEMP_ECOLAB_PERSONS TE WHERE P.PERSON=TE.PERSON)

SET

P.JOBTITLE=TE.JOBTITLE,

P.LAST_NAME=TE.LAST_NAME,

P.FIRST_NAME=TE.FIRST_NAME,

P.DBLOGIN_ID=TE.DBLOGIN_ID,

P.EMAIL_ID=TE.EMAIL_ID,

P.USERLEVEL=TE.USERLEVEL,

P.FACILITY_ID=TE.FACILITY_ID,

P.SUPERVISOR=TE.SUPERVISOR,

P.DEPARTMENT=TE.DEPARTMENT;