SQL Commands

1. Constraints

1.1. NOT NULL

1.2. UNIQUE

1.3. PRIMARY KEY

1.4. FOREIGN KEY

1.5. CHECK

1.6. DEFAULT

1.7. INDEX

2. Aggregate

2.1. COUNT

2.2. MIN

2.3. MAX

2.4. SUM

2.5. AVG

3. Comparison

3.1. =

3.2. <

3.3. <=

3.4. >

3.5. >=

3.6. !=

4. Special

4.1. IN

4.2. LIKE

4.3. BETWEEN

4.4. IS NULL

4.5. EXIST

5. Functions

5.1. DDL

5.1.1. CREATE

5.1.2. ALTER

5.1.3. DROP

5.2. DML

5.2.1. SELECT

5.2.2. UPDATE

5.2.3. INSERT

5.2.4. DELETE

5.2.5. ORDER BY

5.2.6. GROUP BY

5.2.7. WHERE

6. Data Types

6.1. Numeric

6.1.1. NUMBER (L,D)

6.1.2. INTEGER

6.1.3. DECIMAL (L,D)

6.2. Character

6.2.1. VARCHAR (L)

6.2.2. CHAR (L)

6.3. Date

7. Logical

7.1. AND

7.2. OR

7.3. NOT