insert into select 语句

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;