O'Reilly logo

Oracle® SQL by Example, Third Edition by Alice Rischert

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

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

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