O'Reilly logo

Oracle® SQL by Example, Fourth 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 11. Insert, Update, and Delete

In Chapters 1 through 10, 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, which are known as Data Manipulation Language (DML).

These statements enable you to create, change, or delete data from tables. In Lab 11.1 you will learn about creating data in tables with the different INSERT command options and how to make these changes permanent. Lab 11.2 illustrates how to delete data and shows various ways to change existing ...

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