생능_ORACLE배움터_04장. SQL : INSERT, DELETE, UPDATE 문, 트리거(TRIGGER)

Posted on: 2019년 07월 23일 2019년 07월 23일
Categories: 강의자료, 데이터베이스

INSERT 문

INSERT INTO DEPARTMENT VALUES(5, '연구', '');

INSERT INTO HIGH_SALARY(ENAME, TITLE, SAL)
	SELECT EMPNAME, TITLE, SALARY
	FROM EMPLOYEE
	WHERE SALARY >= 3000000;

INSERT INTO DEPARTMENT VALUES(5, '연구', '');

INSERT INTO HIGH_SALARY(ENAME, TITLE, SAL)

SELECT EMPNAME, TITLE, SALARY

FROM EMPLOYEE

WHERE SALARY >= 3000000;

DELETE 문

DELETE FROM DEPARTMENT WHERE DEPTNO = 4;

1

DELETE FROM DEPARTMENT WHERE DEPTNO = 4;
UPDATE 문

UPDATE EMPLOYEE SET DNO = 3, SALARY = SALARY * 1.05 WHERE EMPNO = 2106;

1
2
3

UPDATE EMPLOYEE
SET DNO = 3, SALARY = SALARY * 1.05
WHERE EMPNO = 2106;
트리거(Trigger)
주장(Assertion)

whan0623

517