Manipulating Data With SQL Statements

Previous

Next

Data manipulation language (DML) statements query or manipulate data in existing schema objects. They enable you to:

• Add new rows of data into a table or view (INSERT)

• Change column values in existing rows of a table or view (UPDATE)

• Remove rows from tables or views (DELETE)

DML statements are the most frequently used SQL statements.

This section contains the following topics:

• Adding Data With the INSERT Statement

• Updating Data With the UPDATE Statement

• Deleting Data With the DELETE Statement