hi experts,

i just want to create a trigger , that inserts into VALOR(dt_inser)
column the sysdate each time there is a insert commant on the VALOR
table.
i dont know how to declare sysdate.
(dt_inser date null) column .
thanks for your suggestions.

CREATE OR REPLACE TRIGGER trg_dt_inser
before insert
on VALOR for each row
begin
insert into VALOR(dt_inser) values('sysdate');
end trg_dt_inser;


david...

Oracle LazyDBA home page