2020.09.22 sql 과제

 

CREATE TABLE emp ( emp NUMBER(4) PRIMARY KEY, 

ENAME VARCHAR2(10), job VARCHAR2(10), mgr NUMBER(4) , 

hiredate DATE , sal NUMBER(7,2) , COMM NUMBER(7,2) , 

deptno(2) REFERENCES dept (deptno)