4.2.1Data Manipulation Language-SELECT

DML – SELECT, INSERT, UPDATE and DELETE statements.

The SELECT statement :

1. General form

2. Nested SELECT statements

3. Date Arithemetic Arithmetic Expressions

4. Numeric Functions

5. Date Functions

Character Expressions & Functions
- Concatenate operator & Group Functions



The INSERT statement


The UPDATE statement


The DELETE statement