title: Updating Multiple Columns from another table - Need Oracle format
body: <p>I have a script that I use in SQL Server but I need to convert it to an Oracle format. Can anyone help?</p>
  
  <pre><code>    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;
  </code></pre>
  
  <p>--From the article below I came up with the following statement. It still doesn't work unfortunately:</p>
  
  <pre><code>  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; 
  </code></pre>