[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
);

DESC DEPT_CONST;

 

2.

CREATE TABLE EMP_CONST(
    EMPNO   NUMBER(4) CONSTRAINT EMPCONST_EMPNMO_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.

DESC EMP_CONST;
SELECT OWNER, TABLE_NAME, CONSTRAINT_NAME, CONSTRAINT_TYPE
  FROM USER_CONSTRAINTS
 WHERE TABLE_NAME LIKE '%_CONST'
 ORDER BY CONSTRAINT_NAME ASC;

 

< 정답 >

- 추후 추가-