oracle insert 多行 select

insert into sys_user_role(roleid,userid) select roleid,userid from sys_tmp;

多行插入

insert into sys_user_role(roleid,userid)  select roleid,'$B' userid  from  sys_user_role where userid='$A';