EMP TABLE, DEPT TABLE
DROP TABLE Emp; DROP TABLE Dept; CREATE TABLE Emp (EMPNO INTEGER NOT NULL, ENAME VARCHAR(10), JOB VARCHAR(9), MGR INTEGER, HIREDATE DATE, SAL NUMERIC(7, 2), COMM NUMERIC(7, 2), DEPTNO INTEGER); INSERT INTO Emp VALUES (7369, 'SMITH', 'CLERK', 7902, '2010-02-11', 800, NULL, 20); INSERT INTO Emp VALUES (7499, 'ALLEN', 'SALESMAN', 7698, '2011-02-20', 1600, 300, 30); INSERT INTO Emp VALUES (7521, 'WA..
더보기