我想监视一个视图的TRIGGER,即当视图更新时候把更新的数据时间写入一个表
如下:
CREATE OR REPLACE TRIGGER TRIGGER_SPY
instead of update on vw_ladle_status
for each row
begin
update ladlemaintancespy set updatetime=localtimestamp;
end TRIGGER_SPY;写入ladlemaintancespy的UPDATETIME字段,可是好象没有作用啊
如下:
CREATE OR REPLACE TRIGGER TRIGGER_SPY
instead of update on vw_ladle_status
for each row
begin
update ladlemaintancespy set updatetime=localtimestamp;
end TRIGGER_SPY;写入ladlemaintancespy的UPDATETIME字段,可是好象没有作用啊
--
update ladlemaintancespy set updatetime=To_Char(SYSDATE,'MM-DD-YYYY HH24:MI:SS');