SQL : Structure Query Language is a means of communicating of Database via set of instructions.
Types of SQL Statement :
- DDL – Data Definition Language
- Create, Alter, Drop, Truncate
- These are autocommit commands
- DML – Data Manipulation Language
- Insert, Update, Delete, Merge
- DCL – Data Control Language
- Grant, Remove
- TCL – Transaction Control Language
- Commit, Rollback, Savepoint
- DRL – Data Retrieval Language
- Select statement
Other variant
- Session Control Statement
- Alter session (for NLS etc)
- System Control Statement
- Alter system