O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required