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

在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条数据。