Oracle插入(如果不存在)语句 [英] Oracle insert if not exists statement
本文介绍了Oracle插入(如果不存在)语句的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
insert into OPT (email, campaign_id) values('mom@cox.net',100)
where not exists( select * from OPT where (email ="mom@cox.net" and campaign_id =100)) ;
错误报告:SQL错误:ORA-00933:SQL命令未正确结束 00933. 00000-"SQL命令未正确结束" *原因:
*动作:
Error report: SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended" *Cause:
*Action:
如果Oracle中不存在新行，如何插入?
how to insert a new row if it doesn't exists in Oracle?
推荐答案
insert into OPT (email, campaign_id)
select 'mom@cox.net',100
from dual
where not exists(select *
from OPT
where (email ="mom@cox.net" and campaign_id =100));
这篇关于Oracle插入(如果不存在)语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
