DDL DML DCL TCL
来源:互联网 发布:淘宝里的折800在哪里 编辑:程序博客网 时间:2024/05/07 22:04
DDL
Data Definition Language (DDL) statements are used to define the database structure or schema. 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
- RENAME - rename an object
DML
Data Manipulation Language (DML) statements are used for managing data within schema objects. Some examples:
- SELECT - retrieve data from the a database
- 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
- MERGE - UPSERT operation (insert or update)
- CALL - call a PL/SQL or Java subprogram
- EXPLAIN PLAN - explain access path to data
- LOCK TABLE - control concurrency
DCL
Data Control Language (DCL) statements. Some examples:
- GRANT - gives user's access privileges to database
- REVOKE - withdraw access privileges given with the GRANT command
TCL
Transaction Control (TCL) statements are used to manage the changes made by DML statements. It allows statements to be grouped together into logical transactions.
- COMMIT - save work done
- SAVEPOINT - identify a point in a transaction to which you can later roll back
- ROLLBACK - restore database to original since the last COMMIT
- SET TRANSACTION - Change transaction options like isolation level and what rollback segment to use
- DDL, DML, DCL, TCL
- DDL , DML , DCL , TCL
- DDL DML DCL TCL
- DML DCL DDL TCL
- DML DDL DCL TCL
- DDL, DML, DCL and TCL
- DDL/DML/DCL/TCL基本概念
- DDL&DML&TCL&DQL&DCL
- DDL/DML/DCL/TCL基本概念
- DDL/DML/DCL/TCL基本概念
- Oracle DML DDL DCL TCL
- DDL/DML/DCL/TCL基本概念
- 数据库DDL,DML,DCL,TCL
- DDL、DQL、TCL、DML、DCL
- What means DDL, DML, TCL and DCL?
- 区分DQL、DML、DDL、DCL、TCL
- Oracle DDL,DML,DCL,TCL 基础概念
- Oracle DDL,DML,DCL,TCL 基础概念
- 激活博客
- .NET Framework类库基础编程命名空间
- c#实现闪屏Splash效果示例
- VS 2005 或 VS 2008 在安装VSS 2005后,看不到"源代码管理"的解决办法
- 如何用Google Analytics监测百度竞价广告
- DDL DML DCL TCL
- DNS解析及A记录/MX记录等
- FCKeditor插件开发及使用
- Flex 校验 -- 文本框
- Google Analytics的申请与配置
- 类Shell程序的简化实现(from 《Unix环境高级编程》)
- 易中天讲的很有哲理的十句话
- 获得表的字段参数
- 在Analysis Services项目中出现“未将对象引用设置到对象的实例”