Data Manipulation Operations

Database Manipulation operations – insert, update, upsert, delete, undelete & merge. Use Data Manipulation Language (DML) Operations to insert, update, delete, and restore data in a database. 

1. SELECT- Retrieve data from the database.

2. INSERT- Insert data into a table.

3. UPDATE- Updates existing data within a table.

4. DELETE-  Delete all records from a table. The space for the record remains empty.

5. MERGE- UPSERT operation (Insert or Update).

6. CALL-  Call a PL/SQL or JAVA subprogram.

7. LOCK TABLE- Control concurrency.