oracle loop

 
 

declare

  a integer;

begin

  a := 6;

   loop

    exitwhen(a > 200);

    a := a + 1;

    insertinto HAPS_DATA_T_bill_tran_detail

      (ACCOUNT_NO,

       BILL_DATE,

       RECORD_SIGN,

       SYSTEM_NO,

       TRANS_DATE,

       ENTER_DATE,

       CARD_LAST_4,

       TRANS_DESC,

       ENTER_AMT,

       REFERENCE_NBR,

       TRAN_TYPE,

       TRAN_CODE,

       GRANT_CODE,

       MCC,

       CONSUME_ADDR,

       TRAN_AMT,

       TRAN_CURR_TYPE,

       FCD,

       LCD,

       CARD_NBR,

       FLAG_RETURNGOOD)

    values

      ('2998009882568034',

       '20180923',

       'C001',

       1000000000+a,

       '20180923',

       '20180923',

       '',

       ' 利息',

       2.78,

       '10000000010923999979680',

       'D',

       '226',

       '',

       '00000',

       '',

       0.00,

       '',

       '20160411160403',

       '20160411160403',

       '',

       '');

    commit;

  endloop;

 

end;

 

 

 

 

谢谢！

 

609122