trigger.sql

学习PL/SQL时收集的一些经典的SQL源代码

create table dept_yu(
old_deptno	number(2), 
new_deptno  	number(2),
old_dname	varchar2(14),
new_dname	varchar2(14),
old_loc		varchar2(13),
new_loc    	varchar2(13),
username	varchar2(20),
action_date	date);

CREATE OR REPLACE TRIGGER dept_yu
  AFTER INSERT OR DELETE OR UPDATE
	  ON dept
	  FOR EACH ROW
BEGIN
  INSERT INTO dept_yu
    VALUES (:old.deptno,:new.deptno,:old.dname,:new.dname,:old.loc,:new.loc,USER,SYSDATE);
END;
/