怎么在Oracle中创建时间戳的触发器代码
代码怎么写
创建个触发器就可以了。测试脚本如下:1、创建测试表GetSysDate_Test:create table GetSysDate_Test(t_id number,t_date date);2、编写触发器trg_test:create or replace trigger trg_testbefore insert on GetSysDate_Testfor each rowwhen (new.t_date is null)declarebeginselect sysdate into :new.t_date from dual;end trg_test;3、插入一条数据看效果:insert into GetSysDate_Test(t_id)values(1);commit;select * from GetSysDate_Test;
上一篇:usb性能调试
热门标签: