oracle/DB 연습
-
부서(DEPT) 와 사원(EMPLOYEE) 테이블 연습oracle/DB 연습 2022. 12. 13. 18:43
CREATE TABLE DEPT( deptno number(2) constraint pk_deptno PRIMARY KEY, dname varchar2(14), loc varchar2(13) ); CREATE TABLE EMPLOYEE( empno number(4) constraint pk_empno PRIMARY KEY, ename varchar2(10) NOT NULL, job varchar2(9), ngr number(4) NOT NULL, hiredate date, sal number(7) NOT NULL, comm number(7), deptno number(2) ); --외래키(foreign) 추가 ALTER TABLE EMPLOYEE ADD CONSTRAINT FK_DEPTNO FOREIGN..