DML DCL DDL DQL 比較

No Auto Commit Transaction
-> DML(Data Manipulation Language) : Insert、Update、Delete

example :

Insert into tableName(c1) values (1);

Update tableName set c1 = 1;

Delete tableName where c1 = 1;
-> DQL(Data Query Language)：Select

example :

Select * from tableName;

Auto Commit Transaction
-> DCL(Data Control Language) : Grant、Revoke

example :

Grant select, update, delete, insert on tableName to user;

Revoke select, update, delete, insert on tableName from user;
-> DDL(Data Definition Language) : Create、Alter、Drop

example :

Create table tableName (c1 int, c2 varchar2(20));

Alter table tableName add column c3 date;

Drop table tableName;