The REFERENCING NEW AS NEW OLD AS OLD
lets you specify correlation names. You can use correlation names in the PL/SQL block and WHEN condition of a row trigger to refer specifically to old and new values of the current row. The default correlation names are OLD and NEW. If your row trigger is associated with a table named OLD or NEW, use this clause to specify different correlation names to avoid confusion between the table name and the correlation name.If the trigger is defined on a nested table, then OLD and NEW refer to the row of the nested table, and PARENT refers to the current row of the parent table.
If the trigger is defined on an object table or view, then OLD and NEW refer to object instances.在一般情况下你可以不管这句话:REFERENCING
NEW AS NEW ,如果你的触发器是建在一个表名为new或old的表中,你就可以用这句来给插入或删除的数据定义一个新的别名。
lets you specify correlation names. You can use correlation names in the PL/SQL block and WHEN condition of a row trigger to refer specifically to old and new values of the current row. The default correlation names are OLD and NEW. If your row trigger is associated with a table named OLD or NEW, use this clause to specify different correlation names to avoid confusion between the table name and the correlation name.If the trigger is defined on a nested table, then OLD and NEW refer to the row of the nested table, and PARENT refers to the current row of the parent table.
If the trigger is defined on an object table or view, then OLD and NEW refer to object instances.在一般情况下你可以不管这句话:REFERENCING
NEW AS NEW ,如果你的触发器是建在一个表名为new或old的表中,你就可以用这句来给插入或删除的数据定义一个新的别名。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货