方法一
INSERT ALL
INTO RE_SERVICE_CONFIG(id,networktype_id,servicetype_id,bigservice_id) values (lower(sys_guid()),‘6c97309a-685a-444b-a842-26e006d58641’,d,t)
SELECT c.id d,e.id t
FROM RE_SERVICE_TYPE c,RE_BIG_SERVICE e
WHERE c.name =‘test’ and e.name = ‘test’;
方法二
insert into RE_SERVICE_CONFIG
with a as (
select id from RE_SERVICE_TYPE where
name = ‘test’
),
b as (select id from RE_BIG_SERVICE where
name = ‘test’)
select lower(sys_guid()) as ID, ‘6c97309a-685a-444b-a842-26e006d58641’ as NETWORKTYPE_ID, a.id as SERVICETYPE_ID,b.id as BIGSERVICE_ID from a,b