oracle批量增加测试数据

oracle批量增加测试数据

DECLARE I number := 0; 
BEGIN 
    FOR I IN 0..10000 LOOP 
        INSERT INTO FSP_EDS.EDS_ACCOUNT_ARCHIVES
(ID, VERSION, ARCHIVES_CODE, EDS_CATEGORY_CODE, LE_CODE, LE_NAME, SOB_CODE, SOB_NAME, ACCOUNT_YEAR, ACCOUNT_PERIOD, APPLY_DATE, ARCHIVES_DATE, ACCOUNT_CODE, ACCOUNT_NAME, VOUCHER_TYPE_CODE, ORIGINAL_NUM, REPORT_TYPE_CODE, ARCHIVES_NAME, DRAFTER_NAME, DRAFTER_ID, OPERATOR_NAME, OPERATOR_ID, RECONCILIATION_NO, BANK_NAME, BANK_BRANCH_NAME, BANK_ACCOUNT_NAME, BANK_ACCOUNT_NUM, START_DATE, END_DATE, VERSION_NUM, VERSION_NAME, TAX_TYPE, TAX_PAYING_COMPANY, TAXPAYER_ID_NUM, TAXPAYER_NAME, DEPT_CODE, DEPT_NAME, REASON, PURPOSE, REMARK, STANDARD_CURRENCY_CODE, OPENING_BALANCE, TOTAL_MONTH_AMOUNT, TOTAL_YEAR_AMOUNT, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE, ENABLED_FLAG, HANDOVER_STATUS, ARCHIVE_STATUS, PHYSICS_BORROW_FLAG, ELECTRIC_GRANT_COUNT, IS_ON_SHELF, IS_ELECTRIC, VALIDITY_FLAG, SOURCE_FROM, REPORT_NAME, ARCHIVES_PAGE, SECRETS_DEGREE, STORAGE_MODE, ORG_CODE, ORG_NAME, ARCHIVE_SOURCE_TYPE, STORE_AREA_CODE)
VALUES(129041+ I, 0, 'DYQH-KUAB-2024-D08-0000'|| I, 'KUAB', '100000000', '东亚前海证券总部', NULL, NULL, '2024', '2024-05', NULL, TIMESTAMP '2024-05-16 00:00:00.000000', NULL, NULL, NULL, '测试05161' || I, NULL, '测试05161' || I, 'admin', 50000002, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50000002, TIMESTAMP '2024-05-16 10:19:57.000000', 50000002, TIMESTAMP '2024-05-16 10:19:57.000000', 'Y', 'FOR_HANDOVER', 'FOR_BOOK', 'N', NULL, 'N', 'N', 'Y', 'EDS', NULL, 1, '1', 'B', NULL, NULL, 'HAND', 'NA');
    END LOOP; 
    COMMIT; 
END;