本文介绍了Oracle 插入如果不存在语句的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着跟版网的小编来一起学习吧！
问题描述
插入 OPT (email, campaign_id) values('mom@cox.net',100)哪里不存在(选择 * from OPT where (email ="mom@cox.net" and campaign_id =100))；<块引用>
错误报告:SQL 错误:ORA-00933:SQL 命令未正确结束00933. 00000 - SQL 命令未正确结束"*原因:
*动作:
如果 Oracle 中不存在新行，如何插入新行?
解决方案
insert into OPT (email, campaign_id)选择 'mom@cox.net',100从双重不存在的地方(选择*来自OPTwhere (email ='mom@cox.net' and campaign_id =100));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)) ;
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 'mom@cox.net',100
from dual
where not exists(select *
from OPT
where (email ='mom@cox.net' and campaign_id =100));
这篇关于Oracle 插入如果不存在语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！
本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益，请联系我们，我们会在确认后第一时间进行删除！