ORACLE中INSERT插入多条数据

insert ALL into u_role_permission(rid,pid) values (4,12)

into u_role_permission(rid,pid) values (3,4) into u_role_permission(rid,pid) values (3,6)

into u_role_permission(rid,pid) values (3,7) into u_role_permission(rid,pid) values (3,13) into u_role_permission(rid,pid) values (3,14)

into u_role_permission(rid,pid) values(3,15) into u_role_permission(rid,pid) values (3,16) into u_role_permission(rid,pid) values(3,17)

select 1 from dual;

转载于:https://www.cnblogs.com/leixiaochen/p/8435156.html