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 accessPRivileges to database REVOKE - withdraw access privileges given with the GRANT command
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
3、DCL（DATA CONTROL LANGUAGE）数据控制语言
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 感觉是要好那么一点了，至少不那么糊涂了，毕竟自己也学了那么久，不能什么都不知道三，不能只晓得就一个create、update、drop，嘿嘿！！！
