Database Tutorial

Course Tutorial Site

Site Admin

Articles

without comments

Week 11: Articles

The article for this week focuses on learning how to use the MERGE statement. The MERGE statement is a conditional statement that lets you insert or update rows in a table.

The conditional logic of a MERGE statement depends on your using an embedded query with an outer join. The inner join result typically updates the target row and the outer join result inserts new data into the table. However, you must also meet the logic of a comparison operation that you set in the MERGE statement.

Articles

Written by michaelmclaughlin

August 11th, 2018 at 4:04 pm

Posted in