Pro Oracle SQL Development: Best Practices for Writing Advanced Queries

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

J. HellerPro Oracle SQL Developmenthttps://doi.org/10.1007/978-1-4842-8867-2_8

8. Modify Data with Advanced DML

Jon Heller¹  

(1)

Clive, IA, USA

 

Now that we learned how to write advanced SQL statements to retrieve data, it is time to learn how to write advanced SQL statements to change data. Oracle Data Manipulation Language (DML) lets us insert, update, and delete data.¹

Oracle provides four main statements for changing data: INSERT, UPDATE, DELETE, and MERGE. Each of these statements has advanced options specific to that command. There are also advanced features relevant to all DML statements: updatable views, hints, error logging, and the returning clause. ...