DDL (create, alter, drop, truncate)
DML (select, insert, update, delete)
DCL (commit, rollback, grant, revoke)
create table
create sequence
drop table
drop sequence
오라클 자료형 (number, varchar2, date, char)
- where
- join ... on
- group by ... having
- order by ... asc/desc
- extract(YEAR/MONTH/DATE/HOUR/MINUTE/SECOND from column)
- floor(floating number)
- sum, avg, max, min, cnt
- || (문자열 더하기)
- primary key
- unique
- not null
- default
- check
- foreign key
'DBMS > Oracle' 카테고리의 다른 글
연도별 입사 인원수 체크 (0) | 2023.04.17 |
---|---|
제약조건과 시퀀스 (0) | 2023.04.13 |
HR1, HR2 (0) | 2023.04.13 |
recyclebin (0) | 2023.04.13 |
Product (0) | 2023.04.13 |