Oracle actually has upsert functionality. It is called Merge and has been available for quite a long time: http://docs.oracle.com/cd/B28359_01/server.111/b28286

Oracle actually has upsert functionality. It is called Merge and has been available for quite a long time: http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9016.htm http://docs.oracle.com/cd/B28359_01/server.111/b28286/statem...