Data Manipulation Language

Data Manipulation Language (DML) statements are used for managing data within tables. Some commands of DML are:

1. SELECT - retrieve data from the a database
2. INSERT - insert data into a table
3. UPDATE - updates existing data within a table
4. DELETE - deletes all records from a table, the space for the records remain
5. MERGE - UPSERT operation (insert or update)
6. CALL - call a PL/SQL or Java/php subprogram
7. LOCK TABLE - control concurrency