oracle从多表中获取数据，然后用一条sql语句插入多条数据

insert into  user_role  
select a.sys_role_id,b.sys_user_id from
(select s.sys_user_id from sys_user s where s.user_acct = 'SUPPORT_HQ') b ,

(select s.sys_role_id from sys_role s where s.role_name　in ('UO_%_SUPPORT','UO_%_SUPPORT_QRY','UO_%_PUSH')) a ;