Oracle Equivalent to MySQL INSERT IGNORE?

by

If you’re on 11g you can use the hint IGNORE_ROW_ON_DUPKEY_INDEX:

SQL> create table my_table(a number, constraint my_table_pk primary key (a));

Table created.

SQL> insert /*+ ignore_row_on_dupkey_index(my_table, my_table_pk) */
  2  into my_table
  3  select 1 from dual
  4  union all
  5  select 1 from dual;

1 row created.

More Related Contents:

  1. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  2. How do I escape a reserved word in Oracle?
  3. How to put more than 1000 values into an Oracle IN clause [duplicate]
  4. ORA-30926: unable to get a stable set of rows in the source tables
  5. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  6. Fetch Oracle table type from stored procedure using JDBC
  7. TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
  8. “Safe” TO_NUMBER()
  9. Prevent auto increment on MySQL duplicate insert
  10. ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client
  11. Using the “IN” clause with a comma delimited string from the output of a replace() function in Oracle SQL
  12. Oracle JDBC and Oracle CHAR data type
  13. Does Oracle have an equivalent of SQL Server’s table variables?
  14. check if “it’s a number” function in Oracle
  15. Reason why oracle is case sensitive?
  16. Faster alternative in Oracle to SELECT COUNT(*) FROM sometable
  17. Oracle date difference to get number of years
  18. SQL Fiddle Output Error
  19. oracle PL/SQL how to calculate range ip for IPv6 cidr
  20. if (select count(column) from table) > 0 then
  21. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  22. Oracle: how to add minutes to a timestamp?
  23. How to drop multiple interval partitions based on date?
  24. How to list active / open connections in Oracle?
  25. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  26. Why cannot I create triggers on objects owned by SYS?
  27. No more data to read from socket
  28. automating rollback script oracle
  29. How do I get column datatype in Oracle with PL-SQL with low privileges?
  30. How to View Oracle Stored Procedure using SQLPlus?

Leave a Comment