*DBMS는 SQL( Structured Query Language)문을 사용하여 테이블조작
- DDL ( Data Definition Language ) : 정의어
create, drop, truncate, alter
- DCL (Data Control Language ) : 제어어
commit, rollback, grant, revoke
- DML ( Data Manipulation Language ) : 조작어
insert, update, delete, select
'SQL Oracle' 카테고리의 다른 글
| [SQL] PRIMARY & FOREIGN KEY, UNIQUE, NOT NULL, NVL (0) | 2025.04.14 |
|---|---|
| [SQL] SYSDATE, SUM, MAX, MIN, GROUP BY, VALUES (0) | 2025.04.11 |
| [SQL] to_char, instr, substr, length, initcap, as (0) | 2025.04.10 |
| [SQL] CRUD (0) | 2025.04.08 |