语句类型:
1.DDL (Data Definition Language )数据库定义语言 statements are used to define the database structure or schema.
DDL不需要commit.
CREATE/ALTER/DROP/TRUNCATE/COMMENT/RENAME
2.DML (Data Manipulation Language)数据操纵语言 statements are used for managing data within schema objects.
需要commit.
INSERT/UPDATE/DELETE/MERGE/CALL/EXPLAIN PLAN/LOCK TABLE
3.DCL(Data Control Language)数据库控制语言 授权,角色控制等
GRANT/REVOKE
4.TCL(Transaction Control Language)事务控制语言
SAVEPOINT 设置保存点/ROLLBACK 回滚/SET TRANSACTION
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24751738/viewspace-707567/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24751738/viewspace-707567/