DML
Data Manipulation Language statements query or manipulate data in existing logical schema objects. Common commands are SELECT, INSERT, UPDATE, DELETE, and MERGE. For example, you can use DML statements to:
- View (SELECT) data in one or more tables or views
- Change (UPDATE) column values in existing table rows
- View (EXPLAIN) the optimizer execution plan
- Add (INSERT) new rows to a table
- Remove (DELETE) rows from a table
- Insert (MERGE) a batch of new records while simultaneously updating existing
While DDL statements let you change the structure of the database, DML statment lets you query or change the contents.