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