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;
来源: http://www.bubuko.com/infodetail-3682986.html