【Oracle】根据查询的结果批量插入新数据

话不多说，给个例子：

insert into user_role (IS_USERRIGHT, USER_ID, ROLE_ID, RULE_ID)
select 1, g.id, 111, 0
from gu g where g.start_date like to_date('2020-01-03','yyyy-mm-dd') and g.code not in ('T111');