create table EMP empno INT4 not null ename VARCHAR10 job VARCHAR9 mgr INT4 hiredate DATE sal decimal72 comm decimal72 deptno INT2;-- CreateRecreate primary unique an

CREATE TABLE EMP ( empno NUMBER(4) not null, ename VARCHAR2(10), job VARCHAR2(9), mgr NUMBER(4), hiredate DATE, sal NUMBER(7,2), comm NUMBER(7,2), deptno NUMBER(2) ); -- Create/Recreate primary, unique and foreign key constraints ALTER TABLE EMP ADD CONSTRAINT PK_EMP PRIMARY KEY (EMPNO); ALTER TABLE EMP ADD CONSTRAINT FK_DEPTNO FOREIGN KEY (DEPTNO) REFERENCES DEPT (DEPTNO);