当前位置：首页 > 数据库 > 正文

Oracle 将另外一张表的列更新到本表的列

update temp_agentpay_df q set q.up_batch_bizid=(select c.batch_bizid from temp_df_id c where c.detail_id=q.detail_id) ;

update temp_agentpay_df q,temp_df_id c set q.up_batch_bizid=c.batch_bizid where c.detail_id=q.detail_id;