–실습1 CREATE TABLE EXAM_EMP AS SELECT * FROM EMP; CREATE TABLE EXAM_DEPT AS SELECT * FROM DEPT; CREATE TABLE EXAM_SALGRADE AS SELECT * FROM SALGRADE; INSERT INTO EXAM_EMP(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values(7201,’TEST_USER1′,’MANAGER’ , 7788 , ‘2016/01/02′, 4500,NULL,50); INSERT INTO EXAM_EMP(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values(7202,’TEST_USER2′,’CLERK’ , 7201 , ‘2016/02/21′, 1800,NULL,50); INSERT INTO EXAM_EMP(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values(7203,’TEST_USER3′,’ANALYST’ , 7201 , ‘2016/04/11’, 3400,NULL,60) ; INSERT INTO … Read more