摘要:
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 ... 阅读全文