DDL,DML,DCL區別
What are the difference between DDL, DML and DCL commands?
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
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/27009266/viewspace-743637/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- DML、DDL、DCL區別
- 資料庫:淺談DML、DDL、DCL的區別資料庫
- DDL、DML、DCL、DQL相關操作
- Mysql 基礎操作 DDL DML DCLMySql
- Oracle DDL,DML,DCL,TCL 基礎概念Oracle
- DDL,DML,DCL,TCL四種語言的簡介
- MySQL--基礎知識點--DDL/DCL/DML/DPL/DQL/CCLMySql
- SQL學習___02:DDL+DCL語法SQL
- DML操作 DDL觸發器觸發器
- oracle support nologging ddl dmlOracle
- performing DML/DDL operation over object in binORMObject
- Begin end程式碼段裡面有DDL和DML,如果DDL成功了而DML失敗了,則DDL的程式碼也會回滾
- oracle goldengate 配置DML&DDL實驗OracleGo
- Oracle DBLINK 抽數以及DDL、DML操作Oracle
- 使用Logminer工具分析DML和DDL操作
- DML, DDL操作的自動提交問題
- 配置支援DML和DDL操作同步的GoldenGateGo
- oracle dml產生undo的區別小測試Oracle
- oracle 監控 DML DDL 鎖 的4個檢視Oracle
- DDL,DML操作對結果快取的影響快取
- 【開發篇sql】 基礎概述(三) DDL和DMLSQL
- Mysql資料庫學習(一):資料庫基本概念、關係型資料庫、Mysql資料庫安裝配置、DDL/DCL/DML語句MySql資料庫
- Volatile關鍵字&&DCL單例模式,volatile 和 synchronized 的區別單例模式synchronized
- Oracle DML/DDL同步資料(OGG_12.2_for_Windows)OracleWindows
- ORA-38301:can not perform DDL/DML over objects in Recycle BinORMObject
- Oracle goldengate 11g (二)【DML and DDL單向複製】OracleGo
- oracle---oracle的單向ogg搭建流程(DML+DDL)Oracle
- ORACLE 11g新特性-允許DDL鎖等待DML鎖Oracle
- performing DML/DDL operation over object in bin ORA-38301ORMObject
- MsSql資料庫使用SQL plus建立DDL和DML操作方法SQL資料庫
- oracle dbms_sql執行查詢select_dml_ddl(一)OracleSQL
- MsSql 資料庫使用sqlplus建立DDL和DML操作方法SQL資料庫
- 資料庫審計方案(包括login,logout,DML,DDL等)資料庫Go
- DML DDL 都報ORA-00600: [kntgMvLogObjn]的解決辦法GoOBJ
- MySQL — DCL語言MySql
- 【Flashback】回收站中被標記刪除的表不可以DML和DDL操作
- 在Logical Standby上處理DDL及DML , ORA-16224: Database Guard is enabledDatabase
- DCL之單例模式單例模式