SQL is mainly divided into 4 sub languages

1. Data Definition Language (DDL).These commands are auto commit.

2. Data Manipulation Language (DML).

3. Transaction Control Language (TCL).

4. Data Control Language (DCL).

DDL(  DR CAT)	DML (SUDI)	TCL (CRS)	DCL (GR)
1.DROP	1.SELECT	1.COMMIT	1.GRANT
2.RENAME	2.UPDATE	2.ROLLBACK	2.RENAME
3.CREATE	3.DELETE	3.SAVEPOINT
4.ALTER	4.INSERT
5.TRUNCATE

There are 10 types  Database Objects in Oracle

6 in SQL and 4 in PL/SQL

6 Sql Database Object

1.TABLE

2.VIEWS

3.SYNONYMS

4.SEQUENCE

5.INDEX

6.CLUSTER

4  DATABASE OBJECT IN PL/SQL

1.FUNCTION

2.PROCEDURE

3.PACKAGE

4.TRIGGER