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.1
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. Some additional commands are not technically DML statements but are used ...
