오라클 Day 6

Hyunsu·2023년 4월 21일

oracle

Today I Learned

목록 보기

29/37

📝 목차

Chapter 10 데이터 조작어

Chapter 10 데이터 조작어

📌 문제 1

INSERT INTO CHAP10HW_DEPT (DEPTNO, DNAME, LOC) VALUES (50, 'ORACLE', 'BUSAN'); 
INSERT INTO CHAP10HW_DEPT (DEPTNO, DNAME, LOC) VALUES (60, 'SQL', 'ILSAN');
INSERT INTO CHAP10HW_DEPT (DEPTNO, DNAME, LOC) VALUES (70, 'SELECT', 'INCHEON');
INSERT INTO CHAP10HW_DEPT (DEPTNO, DNAME, LOC) VALUES (80, 'DML', 'BUNDANG');

📌 문제 2

INSERT INTO CHAP10HW_EMP
VALUES (7201, 'MANAGER', 7788, TO_DATE('2016-01-02', 'YYYY-MM-DD'), 4500, NULL, 50);

📌 문제 3

UPDATE CHAP10HW_EMP SET DEPTNO = 70
WHERE SAL > (SELECT AVG(SAL)
			 FROM CHAP10HW_EMP
			 WHERE DEPTNO = 50);

📌 문제 4

UPDATE CHAP10HW_EMP
SET SAL = SAL * 1.1, DEPTNO = 80
WHERE HIREDATE > (SELECT MIN(HIREDATE)
                  FROM CHAP10HW_EMP
                  WHERE DEPTNO = 60);

📌 문제 5

DELETE FROM CHAP10HW_EMP
WHERE EMPNO IN (SELECT E.EMPNO
                FROM CHAP10HW_EMP E, CHAP10HW_SALGRADE S
                WHERE E.SAL BETWEEN S.LOSAL AND S.HISAL
				AND S.GRADE = 5);