Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

Data Manipulation Language (DML)

Oracle’s DML commands are used to add, update, delete, and save values in the database. Five commands are used:

•INSERT	Adds records to a table
•UPDATE	Changes values in a record
•DELETE	Removes records from a table
•ROLLBACK	Restores the database to the condition before the changes were made
•COMMIT	Permanently saves the changes

Using the INSERT Command

The INSERT command is used to add records to the database, and it contains three clauses:

• The TABLE clause. This is the first clause. The target table name follows the INSERT INTO keywords.

• The COLUMNS clause. This is the second clause. It follows the name of the target table. This clause identifies the table columns that will be populated.

• The VALUES clause. ...