08 2011 档案
Oracle 从已知表同步数据
摘要:merge into sm_classes sc using (select * from ceibs_uv_embaclass) c on(sc.id = c.id) when matched then update set sc.classname=c.classname,sc.groupname=c.group_namewhen not matched then insert (sc.id,sc.classname,sc.groupname)values (c.id,c.classname,c.group_name)
阅读全文
浙公网安备 33010602011771号