From the course: Oracle Database 19c: Advanced SQL
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
INTO clause - Oracle Database Tutorial
From the course: Oracle Database 19c: Advanced SQL
INTO clause
- [Narrator] The merge statement can be complex. I'll show you the high level syntax and break down the details of just the into clause. Here is the syntax of the merge statement. I'll focus on the into clause in the following slides. Here's the employee updates table, which is a bit of a misnomer since it will actually be doing inserts, updates and deletes. I'll decide what to do with the row and employees based on the employee ID in employee updates. The next three columns provide an update to the first name, last name, or commission percent columns, if the column is no. The last column, M delete will delete the row and the target table, if it's value is Y. The employee's table has 107 rows and here are a few rows with the employee ID, first name, last name, and the commission percent columns. Given employees updates table in the previous slide, some of these rows will get one or more columns updated, or some rows will be deleted and at least one row will be added. Looking further…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.