请问如何用触发器将本日日期更新到表中？

[qinqindodo]

CREATE TRIGGER "DBSNMP"."T_UPDATE_DM" AFTER
UPDATE OF "C_BZ", "C_BZDM", "C_MC", "N_BXH", "N_DM", "N_FDM", "N_XSSX",
"N_YX"
ON "user"."tabtest"
update tabtest
set d_lasetedit = sysdate
where b_dm.n_bxh = :new.n_bxh
--------------
结果报错说：不能在表级触发器中使用new 何old那么我要如何把条件定位到被修改的那条记录呢？
此外，set d_lasetedit = sysdate这样的写法对吗？

[chanet]

use BEFORE

[CodeMagic]

这样写：
CREATE TRIGGER "DBSNMP"."T_UPDATE_DM" AFTER
UPDATE OF "C_BZ", "C_BZDM", "C_MC", "N_BXH", "N_DM", "N_FDM", "N_XSSX",
"N_YX"
ON "user"."tabtest"
FOR EACH ROW

update tabtest
set d_lasetedit = sysdate
where b_dm.n_bxh = :new.n_bxh
试试

[beckhambobo]

CREATE TRIGGER "DBSNMP"."T_UPDATE_DM" AFTER
UPDATE OF "C_BZ", "C_BZDM", "C_MC", "N_BXH", "N_DM", "N_FDM", "N_XSSX",
"N_YX"
ON "user"."tabtest"
for each row
begin
:new.d_lasetedit:= sysdate;
end;
/

[dinya2003]

表级和行级触发器对该表自身的影响,因为用了表级触发器导致本表变为变异表.

[qinqindodo]

对不起：改为
begin
:new.d_lasetedit= ：sysdate;
end;
后再续该数据时报错：
"触发器T_UPDATE_DM 无效且未通过重新验证"