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 ...

Get Oracle SQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.