트리거

[PLSQL]

PLSQL 트리거 만드는법 CREATE TRIGGER NAME { BEFORE | AFTER } { event [ OR ... ] } ON TABLE [ FOR [ EACH ] { ROW | STATEMENT } ] [ WHEN (...) ] EXECUTE PROCEDURE funcname ( arguments )ex)CREATE TRIGGER salary_trigger BEFORE UPDATE ON employee_table REFERENCING NEW ROW AS n, OLD ROW AS o FOR EACH ROW IF n.salary o.salary THEN ... END IF; *출처 위키백과 PLSQL 내에서 표현방법 SQL PLSQL = := == = != G후에 더 추가하도록...