Oracle中以insert values的形式同时插入多条记录

http://blog.****.net/libertine1993/article/details/52775575

http://blog.****.net/xingxingdezhuyuan/article/details/52463951

举例：

模板：

insert  all into act_id_membership(USER_ID_,GROUP_ID_) values ('cc2','bz')
into act_id_membership(USER_ID_,GROUP_ID_) values('wangba','bz')
into act_id_membership(USER_ID_,GROUP_ID_) values('szx','bzr')
into act_id_membership(USER_ID_,GROUP_ID_) values('sjb','gly')
into act_id_membership(USER_ID_,GROUP_ID_) values('ss','gly')
into act_id_membership(USER_ID_,GROUP_ID_) values('lyj','xfdy')
into act_id_membership(USER_ID_,GROUP_ID_) values('cc2','xs')
into act_id_membership(USER_ID_,GROUP_ID_) values('lisi','xs')
into act_id_membership(USER_ID_,GROUP_ID_) values('ss','xs')
into act_id_membership(USER_ID_,GROUP_ID_) values('wangba','xs')
into act_id_membership(USER_ID_,GROUP_ID_) values('zhangsan','xs')

into act_id_membership(USER_ID_,GROUP_ID_) values('dzt','xsc') select 1 from dual;

结果：