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);