trigger_row_带终端名.txt

来自「orale培训教材包括了所有的sql说明和实例」· 文本 代码 · 共 25 行

drop table audit_emp_values;
CREATE TABLE audit_emp_values
(user_name VARCHAR2(50),
timestamp  DATE, 
id NUMBER(4),
old_last_name VARCHAR2(10), 
new_last_name VARCHAR2(10),
old_title  VARCHAR2(10), 
new_title VARCHAR2(10), 
old_salary NUMBER(7,2), 
new_salary NUMBER(7,2),
frompc varchar2(60));

CREATE OR REPLACE TRIGGER audit_emp_values
AFTER 
DELETE OR INSERT OR UPDATE ON emp
FOR EACH ROW
 BEGIN
    INSERT INTO audit_emp_values (user_name,
     timestamp, id, old_last_name, new_last_name,
      old_title, new_title, old_salary, new_salary,frompc)
    VALUES (USER, SYSDATE, :old.empno, :old.ename,
   :new.ename, :old.job, :new.job, :old.sal, :new.sal,
   userenv('terminal'));
 END;