SQL Statements can be classified as follows.
SQL Statements
|
|
Data Definition Language (DDL)
Database Structure can be created or alter using DDL Statements. Create, alter, drop, rename and truncate are few of them.
DDL Statements are Auto Commit. |
CREATE
ALTER
DROP
RENAME
TRUNCATE
|
Data Manipulation Language (DML)
Once the database structured is created you can insert, update,
delete or merge data.
DML Statements manipulate table's data. |
INSERT
UPDATE
DELETE
MERGE
|
Data Retrieval Language (DRL)
Data Retrieval language retrieves information from tables.
|
SELECT
|
Transaction Control Language (TCL)
Transaction control language controls the transactions.
|
COMMIT
ROLLBACK
SAVEPOINT
|
Data Control Language (DCL)
Data Control Language is used for permission.
|
GRANT
REVOKE
|
No comments:
Post a Comment