Oracle insert if not exists statement

Question

insert into OPT (email, campaign_id) values('[email protected]',100) where not exists( select * from OPT where (email ="[email protected]" 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?

Answer 1

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

Answer 2

The correct way to insert something (in Oracle) based on another record already existing is by using the MERGE statement.

Please note that this question has already been answered here on SO:

• oracle insert if row not exists
• insert if not exists oracle