oracel将excel中的数据根据条件更新到对应的数据中sql脚本

UPDATE CUSTOMERS A -- 使用别名
   SET (CITY_NAME, CUSTOMER_TYPE) =
        (SELECT B.CITY_NAME, B.CUSTOMER_TYPE
           FROM TMP_CUST_CITY B
          WHERE B.CUSTOMER_ID = A.CUSTOMER_ID)
 WHERE EXISTS (SELECT 1 FROM TMP_CUST_CITY B WHERE B.CUSTOMER_ID = A.CUSTOMER_ID);



 update  F_USERINFO A set(
 english_name,reg_cell_phone)=(
 SELECT b.name, B.tel
           FROM F_USERINFO_1028 B
          WHERE B.Login_Name = A.Login_Name
 )WHERE EXISTS (SELECT 1 FROM F_USERINFO_1028 B WHERE B.Login_Name = A.Login_Name);