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