注意:被插入的表中一定要有至少一条记录,因为有数据 列下才对应的值,不然只有列则没有要插入的数据 ,则不会插入成功
ORACLE sql:
1.T_DIC
INSERT INTO T_DIC (
DIC_ID,
DIC_TYPE,
DIC_KEY
)(
SELECT
DISTINCT '199999',
'sys_field_class999',
'apply_info999'
FROM
T_DIC
WHERE
NOT EXISTS (
SELECT
1
FROM
T_DIC
WHERE
DIC_ID = '199999'
)
);
2. t_tmp_person
INSERT INTO "t_tmp_person" (
"t_id",
"name"
)(
SELECT
DISTINCT '33',
'gg'
FROM
"t_tmp_person"
WHERE
NOT EXISTS (
SELECT
1
FROM
"t_tmp_person"
WHERE
"t_id" = '33'
)
);
注意:这里一定要添加 DISTINCT 不然报唯一约束异常:[Err] ORA-00001: unique constraint (GMRJ03.SYS_C0019614) violated