Oracle SQL 的分類DML、DCL、DDL
使用工具sqldeveloper
請先參考 sqldeveloper下載及安裝及連線
測試資料來源請先參考 Oracle DB 目錄
DDL 資料定義語言 Data Definition Language (DDL)
相關指令：
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)
相關指令：
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)
相關指令：
GRANT - gives user's access privileges to database
REVOKE - withdraw access privileges given with the GRANT command
TCL 交易控制語言 Transaction Control (TCL)
相關指令：
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
參考：http://www.xpode.com/ShowArticle.aspx?Articleid=156
其它文章
留言列表
ZK (1)
