Oracle SQL By Example

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