제약조건 오라클

PK KEY 부여

ALTER TABLE emp ADD CONSTRAINT emp_pk_empno PRIMARY KEY (empno) ;

ALTER TABLE DEPT ADD CONSTRAINT DEPT_pk_DEPTno PRIMARY KEY (DEPTNO) ;

FK KEY 부여

ALTER TABLE emp ADD CONSTRAINT emp_fk_deptno FOREIGN KEY (deptno) REFERENCES dept(deptno);