oracle 中如何批量插入表数据

oracle 的插入和mysql 有点不一样,百度了下大概是这样吧,注意一行都不能少哦

insert all
into hlwsb_sjfx.zzs_server_ip_list(IP,ISUSE,NAME) values (‘10.104.121.1‘,1,‘发票下载服务器‘)
into hlwsb_sjfx.zzs_server_ip_list(IP,ISUSE,NAME) values (‘10.104.121.2‘,1,‘发票下载服务器‘)
into hlwsb_sjfx.zzs_server_ip_list(IP,ISUSE,NAME) values (‘10.104.121.3‘,1,‘发票下载服务器‘)
into hlwsb_sjfx.zzs_server_ip_list(IP,ISUSE,NAME) values (‘10.104.121.4‘,1,‘发票下载服务器‘)
into hlwsb_sjfx.zzs_server_ip_list(IP,ISUSE,NAME) values (‘10.104.128.1‘,1,‘受理内存数据库-查验结果服务器‘)
into hlwsb_sjfx.zzs_server_ip_list(IP,ISUSE,NAME) values (‘10.104.128.2‘,1,‘受理内存数据库-勾选结果服务器‘)
select 1 from dual;

oracle 中如何批量插入表数据

上一篇:JQuery 判断checkbox是否选中,checkbox全选,获取checkbox选中值


下一篇:高并发压测工具