这种写法只插入一条是可以执行成功的
如果把select的部分直接写值，也是可以插入多条的
我现在想多条还需要select怎么办

试下这种笛卡尔积实现拼接多行多列内容

insert into "MIDDLEG"."t_sys_config_dictionary"
( "dictionary_name", "dictionary_value", "is_deleted", "sys_config_id", "dictionary_enable")

select "dictionary_name", "dictionary_value", "is_deleted", "sys_config_id", "dictionary_enable"
from (
   select '测试1' "dictionary_name" , '1' "dictionary_value", '2' "is_deleted", '1' "dictionary_enable"
    union all
   select '测试2' "dictionary_name" , '2' "dictionary_value", '2' "is_deleted", '1' "dictionary_enable"
) a, 
(
 select id  "sys_config_id" from "MIDDLEG"."t_sys_config_parent" where param_value = 'warehouseManufacturer'
) b;