批量生成大数据的sql

最新推荐文章于 2024-09-20 11:33:48 发布

ymax_ling

最新推荐文章于 2024-09-20 11:33:48 发布

阅读量812

点赞数

文章标签： sql

本文链接：https://blog.csdn.net/ymax_ling/article/details/68483831

版权

方法一：
declare
cnt number(9);
begin
cnt:=0;
while cnt < 100
loop

insert into ts_customs_fee_fin (ID, FEEDATE, PORT, IEFLAG, BIG_CUSTOM_DEPT, FEE_CODE, FEE_LEVEL, FEE_OCCUR_DATE, CREATEUSER, CREATEDATE, GENERATION_TYPE, LASTUPDATE, LASTUPUSER, CUSTOMS_CLEARANCE_TYPE, TRANSPORT_MODE, CUSTOMS_DATE, CUSBATCH, MAWB, FLIGHTNO, BNO, GATE_TYPE, CARGO_TYPE, LIMIT_TYPE_CODE, PRODUCT_CODE, FEE_SORT, CALCULATE_OBJECT2, ACCOUNT_RULES_ID, ACCOUNT_QUANTITY, FEE, DATA_SOURCE, REMARK, STATE, SUPPLIER_NAME, SRC_ADDR, DES_ADDR, OCCURRATE, CUSTYPE, TAXPAYMENTTYPE, RECON_ID, SERVICE_NAME, BIZ_ID, DEL_MARK, SUPPLIER_CODE, CALCULATE_OBJECT1, EXCEPT_ID, FEE_NAME, GJAHR_MONAT_STR, PROJT, CUSTM, GJAHR_MONAT)
values (SEQ_TS_CUSTOMS_FEE.Nextval, '201609', 'RIO', 'I', '海外', 911, '1', to_date('25-09-2016',