| Acronym | Language | Purpose | Statements | Comments |
|---|---|---|---|---|
| DDL | Data Definition | Define Database | · Create · Alter · Drop · Truncate · Comment · Rename | Autocommit |
| DML | Data Manipulation | Managing data | · Select · Insert · Update · Delete · Merge · Call · Explain Plan · Lock Table | Can rollback |
| DCL | Data Control | Security | · Grant · Revoke | |
| TCL | Transaction Control | Manage DML | · Commit · Savepoint · Rollback · Set Transaction |
No comments:
Post a Comment