DDL, DML, DCL and TCL

本文详细介绍了SQL语言中的三个核心部分:DDL(数据定义语言)、DML(数据操作语言)和DCL(数据控制语言)。涵盖了创建、修改、删除数据库结构,以及数据的增删改查等关键操作。
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

From:

http://www.orafaq.com/faq/what_are_the_difference_between_ddl_dml_and_dcl_commands


评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值