ITPub博客

create table test(tid int ,tdate date); --日期触发器 create or replace trigger test_tdate before insert on test for each row  when (new.tdate is null)   begin   select sysdate into :new.tdate from dual; end; insert into test(tid)values(1);