DDL - Data Definition Language
These are the statements that are used to define the database structure or schema
i.e. CREATE, ALTER, DROP, TRUNCATE, COMMENT, RENAME
DML - Data Manipulation Language
These are the statements are used for managing data within schema objects.
i.e. SELECT , INSERT, DELETE , UPDATE, MERGE
DCL - Data Control Language
These are GRANT and REVOKE
TCL - Transaction Control Language
These are COMMIT, ROLLBACK, COMMIT, SAVEPOINT, SET TRANSACTION
SCL - Session Control Language
i.e ALTER SESSION statements
No comments:
Post a Comment