Oracle: how to INSERT if a row doesn’t exist

by 
INSERT INTO table
SELECT 'jonny', NULL
  FROM dual -- Not Oracle? No need for dual, drop that line
 WHERE NOT EXISTS (SELECT NULL -- canonical way, but you can select
                               -- anything as EXISTS only checks existence
                     FROM table
                    WHERE name="jonny"
                  )

More Related Contents:

  1. What is the replacement of cursor foreach in oracle pl/sql?
  2. Can you SELECT everything, but 1 or 2 fields, without writer’s cramp?
  3. Printing the value of a variable in SQL Developer
  4. PL/SQL, how to escape single quote in a string?
  5. Oracle PL/SQL – Raise User-Defined Exception With Custom SQLERRM
  6. Passing an array of data as an input parameter to an Oracle procedure
  7. Convert comma separated string to array in PL/SQL
  8. UTL_FILE.FOPEN() procedure not accepting path for directory?
  9. Oracle stored procedure with parameters for IN clause
  10. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  11. Get resultset from oracle stored procedure
  12. Oracle PL/SQL – How to create a simple array variable?
  13. ways to avoid global temp tables in oracle
  14. Split function in oracle to comma separated values with automatic sequence
  15. check if “it’s a number” function in Oracle
  16. ORA-06508: PL/SQL: could not find program unit being called
  17. How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?
  18. Create Pivot view in SQL from a SQL table
  19. SQL*Plus how to accept text variable from prompt?
  20. Why doesn’t PL/SQL respect privileges granted by Roles?
  21. if (select count(column) from table) > 0 then
  22. Can We use threading in PL/SQL?
  23. Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?
  24. What is the algorithm used by the ORA_HASH function?
  25. How to output result of SELECT statement which is executed using native dynamic SQL?
  26. passing in table name as plsql parameter
  27. Reading clob line by line with pl\sql
  28. How to use parameters in a ‘where value in…’ clause?
  29. BEGIN – END block atomic transactions in PL/SQL
  30. Escaping single quote in PLSQL

Leave a Comment