ORACLE中将一个值赋值到另一个表的值
摘要：
ORACLE中将一个值赋值到另一个表的值update tmp_customer_list tset email = (select email from tmp_etl_customerlist e where t.mobile = e.mobile);更加高效的方法：merge into customer_list tusing CUSTOMER_LIST_TMP01 t1on(t.customerkey = t1.customerkey)when matched then update set t.customerlevel = t1.customerlevel ;commit; 阅读全文
posted @ 2012-06-04 22:03 艾思派客 阅读(1947) 评论(0) 推荐(0) 编辑