오라클 Day 9

📝 목차

Chapter 14 제약 조건

---

Chapter 14 제약 조건

📌 문제 1

CREATE TABLE DEPT_CONST ( 
	DEPTNO	NUMBER(2)    CONSTRAINT DEPTCONST_DEPTNO_PK PRIMARY KEY, 
	DNAME	VARCHAR2(14) CONSTRAINT DEPTCONST_DNAME_UNQ UNIQUE, 
	LOC		VARCHAR2(13) CONSTRAINT DEPTCONST_LOC_NN NOT NULL 
);

📌 문제 2

CREATE TABLE EMP_CONST ( 
  EMPNO    NUMBER(4)	CONSTRAINT EMPCONST_EMPNO_PK PRIMARY KEY, 
  ENAME    VARCHAR2(10) CONSTRAINT EMPCONST_ENAME_NN NOT NULL, 
  JOB      VARCHAR2(9), 
  TEL      VARCHAR2(20) CONSTRAINT EMPCONST_TEL_UNQ UNIQUE, 
  HIREDATE DATE, 
  SAL      NUMBER(7, 2) CONSTRAINT EMPCONST_SAL_CHK CHECK(SAL BETWEEN 1000 AND 9999),
  COMM     NUMBER(7, 2), 
  DEPTNO   NUMBER(2)    CONSTRAINT EMPCONST_DEPTNO_FK REFERENCES DEPT_CONST(DEPTNO) 
); 

📌 문제 3

SELECT TABLE_NAME, CONSTRAINT_NAME, CONSTRAINT_TYPE 
FROM USER_CONSTRAINTS 
WHERE TABLE_NAME IN ('EMP_CONST', 'DEPT_CONST') 
ORDER BY CONSTRAINT_NAME; 

Reference

• Do it 오라클로 배우는 데이터베이스 입문