利用存储过程批量处理数据并分批量提交

最新推荐文章于 2023-06-29 15:20:44 发布

袁山1997

最新推荐文章于 2023-06-29 15:20:44 发布

阅读量882

点赞数

文章标签：数据库 sql

本文链接：https://blog.csdn.net/csdn_2022_01_01/article/details/127653610

版权

--存储过程--正则表达式--清洗数据--分批量提交
create table t_custmobile(custon int,mobileno varchar(20));
insert all      into t_custmobile values(1,13456789447)
                into t_custmobile values(2,13466789447)
                into t_custmobile values(3,18456789447)
                into t_custmobile values(4,14456789947)
                into t_custmobile values(5,15456489447)
                into t_custmobile values(6,19456789447)
                into t_custmobile values(7,13454689447)
                into t_custmobile values(8,1345659447)
                into t_custmobile values(9,13456789447)
                into t_custmobile values(10,13456786747)
                into t_custmobile values(11,13456780447)
                into t_custmobile values(12,1345689447)
                into t_custmobile values(13,13489447)
                select 1 from dual;
select * from t_custmobile;