Chapter 10. INSERT, UPDATE, and DELETE

In Chapters 1 through 9 you learned what data is and how to query and present data. In this chapter, you will learn how to modify the data in tables with the INSERT, UPDATE, DELETE, and MERGE statements, also known as Data Manipulation Language (DML). These statements give you the ability to create, change, or delete data from tables. In the first lab you will learn about creating data in tables with the different INSERT command options and how to make this change permanent. The second lab illustrates how to delete data and shows various ways to change existing data in the tables. Furthermore, ...

Get Oracle® SQL by Example, Third Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.