Oracle存储过程循环执行sql语句 原创

Oracle存储过程循环执行sql语句

复制收展SQLdeclare
    num     number := 1;
    sql_tem Varchar2(10000);
begin
    while num <= 45000
        loop
            sql_tem :=
                    ' INSERT INTO GTSSCC.CB_BA_TRADE_DETAIL (ID_, ACCOUNTID_, TRADETIME_, DEBITAMOUNT_, CREDITAMOUNT_, BALANCE_, DIGEST_, PURPOSE_, OPPACCOUNTNO_, OPPACCOUNTNAME_, OPPOPENBANKNAME_, BUSINESSTYPE_, SERIALNO_, VOUCHERNO_, OPERATORNO_, GROUPNO_, DATATYPEID_, DATAUPDATETIME_, BILLNO_, TRADINGPLACE_, DATASOURCE_, CREATETIME_, CREATEBY_, LASTUPDATETIME_, LASTUPDATEBY_, ENABLE_, CHECKNO_, BANKWEBNO_, PAYFOUNDNO_, ENTITYACCNO_, LOGNO_, SUMMONSNO_, TRANSACTIONTYPE_, CASHORTRANSFLAG_, TIMESTAMP_, BOOKSNAME_, ISIMPORT_, UNIQUECODE_, VIRTUALACCNO_, VALIDATEFLAG_, RECONCILEDFLAG_, IDENTIFY_, VOUCHERTYPE_, RECEIPTCODE_, TRANSNETCODE_, TRANSTELLNO_, TRANSERIALNO_, AREACODE_, CURCODE_, FEE_, CURRENCYID_) VALUES (cb_ba_TRADE_DETAIL_seq.nextval, 2, sysdate, 1.00, 0.0000, null, ''测试数据'', ''测试数据'', ''1302010129022168186'', ''1333'', ''444'', null, null, null, null, null, 1, sysdate, null, null, ''interface'', sysdate , 30045, sysdate, 30045, 1, null, null, null, null, null, null, null, null, null, null, null, sysdate, null, null, null, null, null, null, null, null, null, null, ''CNY'', 0.0000, 1)';
            dbms_output.put_line(sql_tem);
            EXECUTE IMMEDIATE sql_tem;
            dbms_output.put_line('FOR循环已经结束！');
            num := num + 1;
        end loop;
end;
1
2
3
4
5
6
7
8
9
10
11
12
13
14