insert into IME.BM_MATERIEL_INFO
select 'GD2GDH3QF3FM'||LPAD(rownum,5,0), 'per'||LPAD(rownum,5,0), 'Per'||LPAD(rownum,5,0), '60507713920d4dd8a62f2184c6d91399','','','','','','','','',1,'','','','','','','','','','','','','','','','','','','','','','','','','','fce419c57c6b422ab98223ae6f29e0ae','','','','','','','','','PLSQL',SYSDATE,'','',0,1,'','616118bb4b1240eda298caeb109715d7','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''
FROM xmltable('1 to 50000');
Oracle百万级数据秒级插入
最新推荐文章于 2022-12-13 11:24:15 发布