From the course: Oracle Database 19c: Advanced SQL

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Overview of DML statements

Overview of DML statements - Oracle Database Tutorial

From the course: Oracle Database 19c: Advanced SQL

Start my 1-month free trial

Overview of DML statements

“

- [Instructor] DML statements from an Oracle perspective are different from select statements, adding, changing, and deleting data from tables, versus just reading the data. If you want to make any changes to a table, you use a DML statement. The five DML statements available in Oracle are INSERT, UPDATE, DELETE, and MERGE. The first three are somewhat explanatory. MERGE may not be. A MERGE statement will take one row source and merge it into another. And what that means is that the source row set may have rows that get inserted into the table or updating existing rows or even deleting rows. It's like one stop shopping if you know you want to do three things in a single table. And you don't have to do all three, you can just do one or two. I list TRUNCATE since it does actually delete all the rows in a table very quickly, but it's actually a Data Definition Language, DDL, statement behind the scenes. DML statements can update one row at a time, several, or change the entire table…

Contents