DDL, DML, DCL, and TCP concepts in the database

1.DDL(data definition Language) database definition language, which defines the creation and undo operations of SQL schemas, basic tables, views, and indexes . DDL does not require commit:

create/ drop/ /comment/ Span style= "line-height:1.5;" >rename

2. dml (data Manipulation Language ) data manipulation language, need commit:

select/insert/updatedelete/merge/call/explain plan/lock table/
3. (data Control Language ) database Control Language   authorization, role control, etc. Includes authorization for basic tables and views, description of the integrity rules:
Grant authorization/revoke cancellation
4. (transaction Control Language ) transaction control Language:

SavePoint set Save point/rollback rollback/set TRANSACTION

DDL, DML, DCL, and TCP concepts in the database