O'Reilly logo

Oracle SQL by Carol McCullough-Dieter, Gavin JT Powell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

15

Data Manipulation Language (DML)

In this chapter:

  • What are DML and transaction control?

  • How do you use the INSERT command?

  • How do you update existing rows?

  • How do you delete one or more rows?

  • How do you merge two tables together?

This chapter demonstrates the Data Manipulation Language (DML), showing the syntax and plenty of examples. DML commands are used in SQL to add, modify, and remove rows of data in database tables. Transaction control using ROLLBACK and COMMIT commands, among others, plus the MERGE command, are also covered in this chapter.

In previous chapters we have explored a wide variety of methods and variations of data retrieval. Now, it is time to learn how to make up your own data!

15.1 What Is DML?

Data Manipulation Language ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required