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:
如何在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));
