Oracle 插入如果不存在语句 [英] Oracle insert if not exists statement

问题描述

插入 OPT (email, campaign_id) values('[e-mail]',100)哪里不存在(选择 * from OPT where (email ="[e-mail]" and campaign_id =100))；

<块引用>

错误报告:SQL 错误:ORA-00933:SQL 命令未正确结束00933. 00000 - SQL 命令未正确结束"*原因:
*动作:

如果 Oracle 中不存在新行，如何插入新行?

解决方案

insert into OPT (email, campaign_id)选择 '[e-mail]',100从双重不存在的地方(选择*来自OPTwhere (email ='[e-mail]' and campaign_id =100));

insert into OPT (email, campaign_id) values('[e-mail]',100)
where not exists( select * from OPT where (email ="[e-mail]" and campaign_id =100)) ;

Error report: SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended" *Cause:
*Action:

how to insert a new row if it doesn't exists in Oracle?

解决方案

insert into OPT (email, campaign_id) 
select '[e-mail]',100
from dual
where not exists(select * 
                 from OPT 
                 where (email ='[e-mail]' and campaign_id =100));

这篇关于Oracle 插入如果不存在语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！