Oracle Upsert: Insert or Update
Andrew Martinez
February 22, 2008
Programming/Tech
2 Comments
Tags: collections, forall, merge, Oracle, PL/SQL, sql, upsert
When working with relational data in a stateless environment (e.g. web applications) it is sometimes not known if something is being created (insert) or being updated. This is generally seen when an object has an 0..N number of sub elements.
When the data from the user is to be processed, it would be best to handle both inserting and updating with a single statement. Developers new to databases generally handle this transaction with multiple statements using conditional “IF” statements to determine the number of rows a result set has. Based on the number of rows (0 or 1) an … Continue Reading