[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후에 더 추가하도록...