Upsert method 3: The set based approach Database concepts Add comments Dec 072012 Click the image for copy-pastable scripts to see this in action. As always, Tom Kyte has an answer discussing the benefits of the various upsert approaches. Get SQLfail sent to your inbox Share this:FacebookGoogleTwitter select posts from sqlfail where content like :this_post; Upsert method 2: When you expect to mostly be updating existing data Upsert method 1: When you expect to be mostly adding data Who’s NO_DATA_FOUND is it anyway? More fun with nulls and (bitmap) indexes More ways to prevent a single unusable value breaking your entire statement Leave a Reply Cancel reply Name (required) E-mail (required) URI Your Comment You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> Notify me of follow-up comments by email. Notify me of new posts by email.