摘要: Oracle11g的Merge很强大! 1 create or replace procedure BRANCE_REPORT_MERGE is 2 3 begin 4 Merge into BRANCHREPORT desttable 5 using TEMP_BRANCHREPORT tmptable 6 on (desttable.SENDER_ID=tmptable.SENDER_ID and desttable.BRANCH_ID=tmptable.BRANCH_ID and desttable.REPORT_TIME=tmptable.REPORT_TIME) 7 ... 阅读全文
posted @ 2012-09-24 17:25 太一吾鱼水 阅读(265) 评论(0) 推荐(0) 编辑