Data Manipulation Language (DML) Syntax

The SQL commands that deal with the manipulation of data present in the database belong to DML or Data Manipulation Language and this includes most of the SQL statements. It is the component of the SQL statement that controls access to data and to the database. Basically, Data Control Language (DCL) statements are grouped with DML statements

Data Manipulation Syntax

Insert:

This is used to insert data into a table.

{ INSERT } INTO tablePrimary
[ '(' column [, column ]* ')' ]
[ VALUES '(' column [, column ]* ')' ]           

 

Update:

This is used to update existing data within a table.

UPDATE tablePrimary
SET assign [, assign ]*
[ WHERE booleanExpression ]			

 

Delete:

This is used to delete records from a database table.

DELETE FROM tablePrimary [ [ AS ] alias ]
[ WHERE booleanExpression ]

 

Explain:

Explain plan describes the access path to the data.

EXPLAIN PLAN
   FOR { query }
EXPLAIN ANALYZE
   FOR { query }