在INSERT语句中使用PL/SQL记录

trbmta 表中的主键是SYSCD, BUMCD, BMNCD, TOKCD

DECLARE
       trbmta_record trbmta%ROWTYPE;
       v_bumcd char(4);
BEGIN
       FOR i IN 1..20 LOOP
           IF i<10 THEN
              v_bumcd := '0' || to_char(i);
           ELSE 
              v_bumcd := to_char(i);
           END IF;
         trbmta_record.syscd := '001';
         trbmta_record.bumcd := v_bumcd;
         trbmta_record.bmncd := '001234';
         trbmta_record.tokcd := '100370';
         
         trbmta_record.delkb := '1';
         trbmta_record.WRTINSDT := to_char(sysdate, 'yyyyMMdd');
         trbmta_record.WRTINSTM := to_char(sysdate, 'hhmmss');
         trbmta_record.WRTDT := to_char(sysdate, 'yyyyMMdd');
         trbmta_record.WRTTM := to_char(sysdate, 'hhmmss');
         INSERT INTO trbmta VALUES trbmta_record;     
       END LOOP;     
END;

 执行后，会往数据库中插入20条数据。