There is a MySQL function REPLACE INTO tbl. It is similar to INSERT INTO tbl just if REPLACE is used MySQL looks for Primary Key and if available replaces all other values with new ones otherwise an INSERT will take place.
Is there anything like that in Oracle?
