我有一个我在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.DEPARTMENT=TE.DEPARTMENT;