DDL is Data Definition Language statements . (数据定义语言)
Some examples:
Create -- to create objects in the database (在数据库中创建一个对象)
Alter -- alters the structure of the database (修改数据库的结构)
Drop -- delete objects from the database (从数据库中删除一个对象)
Truncate -- remove all records from a table,including all spaces allocated for the records are removed (从表中移除所有的记录,包括用于存放记录的表空间也将被删除)
Comment -- add comments to the data dictionary (向数据字典中添加注释)
Grant -- gives user's access privileges to the database (向该数据库的用户授权)
Revoke -- withdraw access privileges given whit the Grant command (收回该用户的权限)
DML is Data Manipulation Language statements . (数据操作语言)
Some examples:
Select -- retrieve data from a table (从表中检索数据)
Insert -- insert data into a table (向表中插入数据)
Update -- updates existing data within a table (更新表中存在的数据)
Delete -- deletes all records from a table,the space for the records remain (从表中移除所有的记录,但保存表空间)
Call -- call a PL/SQL or Java subprogram (调用一个PL/SQL程序或一个Java子程序)
Explain Plan -- explain access path to data (解释计划)
Lock table -- control concurrency (并发控制)
DCL is Data Control Language statements . (数据控制语言)
Some examples:
Commit -- save work done (提交当前工作)
Savepoint -- identify a point in a transaction to which you can later roll back (设置一个点以备稍后回滚)
Rollback -- restore databases to original since the last Commit (回滚:将数据恢复到上次提交的状态)
Set transaction -- change transaction options like what rollback segment to use (改变选择使用什么样的回滚段)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10356975/viewspace-680342/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10356975/viewspace-680342/