develog

[Oracle] DDL, DML, DCL, TCL 본문

DB/Oracle

[Oracle] DDL, DML, DCL, TCL

냐옴 2015. 5. 13. 10:06

▶ DDL (Data Definition Language)

- CREATE

- ALTER

- DROP

- TRUNCATE

- RENAME


▶ DML (Data Manipulation Language)

- SELECT

- INSERT

- UPDATE

- DELETE

- MERGE


▶ DCL (Data Control Language)

- GRANT

- REVOKE


▶ TCL (Transaction Control Language)

- COMMIT

- ROLLBACK

- SAVEPOINT



'DB > Oracle' 카테고리의 다른 글

[Oracle] Trigger 생성  (0) 2015.06.19
[Oracle] REF CURSOR  (0) 2015.06.18
[Oracle] 부여된 권한 조회  (0) 2015.01.21
[Oracle] GRANT 조회  (0) 2015.01.13
[Oracle] 테이블 생성시간 확인  (0) 2015.01.06
Comments