INSERT INTO "his_system_typeiteminfo" ("id", "type_id", "item_id")
SELECT
HIS_SYSTEM_TYPEITEMINFO_SQE.NEXTVAL, -- 序列后面必须加.NEXTVAL,不然会报 invalid identifier标识符无效的错误
4,
"id"
FROM
"his_system_cure_item_info"
WHERE
"item_name" LIKE '%影%'
insert into select 语句格式
INSERT INTO table2
(column_name(s))
SELECT column_name(s)
FROM table1;