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;

相关推荐