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


 




 

 








其它文章


arrow
arrow
    文章標籤
    db oracle sql 用法 程式 database dcl ddl transaction records table 指令 insert java rollback dml
    全站熱搜
    創作者介紹
    創作者 PG Levin Li 的頭像
    PG Levin Li

    程式開發學習之路

    PG Levin Li 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄