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 ...
Get Oracle SQL By Example 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.
