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)