CREATE TABLE EMP(
EMPNO INT NOT NULL PRIMARY KEY,
ENAME VARCHAR(30),
JOB VARCHAR(30),
MGR INT,
HIREDATE DATE,
SAL LONG,
COMM LONG,
DEPTNO INT);