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;
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容