触发器。无法更改此触发器的new值

 

create or replace trigger trigger_cell_date
  before insert on tbl_nokia_cell
  referencing old as oldvalue new as newvalue
  for each row
begin
  select to_number(to_char(sysdate,'YYYY')),
         to_number(to_char(sysdate,'MM')),
         to_number(to_char(sysdate,'DD')) INTO :newvalue.YEAR,:newvalue.MONTH,:newvalue.DAY
         FROM DUAL ;

END;

注意只有before insert 才能修改newvalue的值。如果用after会报 oracle 无法更改此触发器的new值