PLSQL :NEW 和 :OLD
谁能帮助我理解何时在 PLSQL 块中使用 :NEW
和 :OLD
,我发现很难理解它们的用法.
Can anyone help me understand when to use :NEW
and :OLD
in PLSQL blocks, I'm finding it very difficult to understand their usage.
推荐答案
您通常在 trigger 使用 :old
引用旧值和 :new
引用新值.
You normally use the terms in a trigger using :old
to reference the old value and :new
to reference the new value.
这里是上面链接的 Oracle 文档中的一个示例
Here is an example from the Oracle documentation linked to above
CREATE OR REPLACE TRIGGER Print_salary_changes
BEFORE DELETE OR INSERT OR UPDATE ON Emp_tab
FOR EACH ROW
WHEN (new.Empno > 0)
DECLARE
sal_diff number;
BEGIN
sal_diff := :new.sal - :old.sal;
dbms_output.put('Old salary: ' || :old.sal);
dbms_output.put(' New salary: ' || :new.sal);
dbms_output.put_line(' Difference ' || sal_diff);
END;
在这个例子中,触发器触发 BEFORE DELETE OR INSERT OR UPDATE
:old.sal
将包含触发器触发之前的薪水和 :new.sal
将包含新值.
In this example the trigger fires BEFORE DELETE OR INSERT OR UPDATE
:old.sal
will contain the salary prior to the trigger firing and :new.sal
will contain the new value.
相关文章