Oracle批量插入sql和Mysql大不一样
mysql写法
insert into TS_TDGPXX (ID,XZQH_DM) values
('fhunjikolp','123'), ('fhunjikolp','123')
oracle写法
insert all into TS_TDGPXX (ID,XZQH_DM) values ('dsjdshfiuhif','123') into TS_TDGPXX (ID,XZQH_DM) values ('fhunjikolp','123') select 1 from dual;
详情可参照:https://www.jb51.net/article/132823.htm