?? regerence.txt
字號:
CREATE OR REPLACE TRIGGER audit_emp_values
AFTER DELETE OR INSERT OR UPDATE ON emp
--REFERENCING old_emp AS :old new_emp AS :new
REFERENCING OLD AS old_emp NEW AS new_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)
VALUES (USER, SYSDATE, :old_emp.empno, :old_emp.ename,
:new_emp.ename, :old_emp.job, :new_emp.job, :old_emp.sal, :new_emp.sal);
END;
REFERENCING [OLD AS :old_name] [NEW AS :new_name]
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -