Oracle insert if not exists statement

by 
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));

More Related Contents:

  1. How to uninstall / completely remove Oracle 11g (client)?
  2. How can I set a custom date time format in Oracle SQL Developer?
  3. Get counts of all tables in a schema
  4. Determining location of relevant tnsnames.ora file
  5. Default row ordering for select query in oracle
  6. oracle convert unix epoch time to date
  7. Oracle trigger after insert or delete
  8. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  9. Difference between a user and a schema in Oracle?
  10. Base64 encoding and decoding in oracle
  11. What is the dual table in Oracle?
  12. PL/SQL – Use “List” Variable in Where In Clause
  13. How do I calculate tables size in Oracle
  14. How to avoid variable substitution in Oracle SQL Developer
  15. Auto-increment in Oracle without using a trigger
  16. Create an Excel Spreadsheet from a Oracle Database
  17. How to send email using Oracle 10 g Forms
  18. How to get primary key column in Oracle?
  19. How to create a user in Oracle 11g and grant permissions
  20. Trigger to enforce M-M relationship
  21. How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
  22. Oracle: how to INSERT if a row doesn’t exist
  23. Valid Date Checks in Oracle
  24. Functions vs procedures in Oracle
  25. Oracle: difference between max(id)+1 and sequence.nextval
  26. HikariCP: What database level timeouts should be considered to set maxLifetime for Oracle 11g
  27. How to call an Oracle function with a Ref Cursor as Out-parameter from C#?
  28. How to Register Pluggable Database(PDB) with new created LISTENER
  29. Grant Select on all Tables Owned By Specific User
  30. ORA-12704: character set mismatch

Leave a Comment