What are the difference between DDL, DML and DCL commands?
来源:互联网 发布:lol全网络大区坑人 编辑:程序博客网 时间:2024/05/02 02:29
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 database
- REVOKE - withdraw access privileges given with the GRANT command
DML is Data Manipulation Language statements. 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
- CALL - call a PL/SQL or Java subprogram
- 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 database to original since the last COMMIT
- SET TRANSACTION - Change transaction options like what rollback segment to use
0 0
- What are the difference between DDL, DML and DCL commands?
- What are the difference between DDL, DML and DCL commands?
- What are the difference between DDL, DML and DCL commands?
- What are the difference between DDL, DML and DCL commands?
- What are the difference between DDL, DML and DCL commands?
- What means DDL, DML, TCL and DCL?
- What's the difference between mvn:deploy and mvn:install commands?
- What is the difference between test, [ and [[ ?
- What are the difference between PCL Driver and PS(PostScript) Driver?
- DDL, DML, DCL and TCL
- what is the difference between the setTimeout and setInterval
- What is the difference between DHTML and the DOM?
- What is the difference between the mouseover and mouseenter events?
- What is the difference between AWT and SWT?
- What's the difference between an event and a delegate?
- what's the difference between OnDraw and OnPaint
- What is the difference between User Control and Custom Control?
- What is the difference between an EXE and a DLL?
- 【Vegas2008】12月20日-克莱德曼苏州音乐会
- 2008年12月23日
- 2008年12月23日
- 喝酒化解大法三十八式(酒前/酒中/酒后)
- 喝酒化解大法三十八式(酒前/酒中/酒后)
- What are the difference between DDL, DML and DCL commands?
- What are the difference between DDL, DML and DCL commands?
- OCP-052
- 【Vegas原创】解决cmd窗口不够使用的方法
- 【Vegas原创】解决cmd窗口不够使用的方法
- 编写程序计算12+22+32+....+1002的和
- 【Vegas原创】SQL2005:provider: 命名管道提供程序, error: 40 - 无法打开到 SQL Server 的连接-解决方法
- 【Vegas原创】SQL2005:provider: 命名管道提供程序, error: 40 - 无法打开到 SQL Server 的连接-解决方法
- <string> 与 <string.h> 的区别