创建一个触发器要求每插入一条数据后,计数字段'ID'自增,并当时间到第二天的时候,计数字段‘ID’归零一直报错啊一直报错在线求各位大侠帮忙create or replace trigger select_count_tempbefore insert on tb_tempfor each rowdeclare nextid number;
updatetime date;begin
IF to_char(sysdate,'HH24:MI') >= '00:00' THEN
:new.id := 0; IF :new.id IS NULL or :new.id=0 THEN select SEQ_SELECTCOUNT.nextval into nextid from sys.dual; :new.id :=nextid; else if :new.id IS NULL or :new.id=0 then select sysdate into updatetime from sys.dual; :new.UPDATE_TIME :=updatetime; end if;
end if;end select_count_temp;
updatetime date;begin
IF to_char(sysdate,'HH24:MI') >= '00:00' THEN
:new.id := 0; IF :new.id IS NULL or :new.id=0 THEN select SEQ_SELECTCOUNT.nextval into nextid from sys.dual; :new.id :=nextid; else if :new.id IS NULL or :new.id=0 then select sysdate into updatetime from sys.dual; :new.UPDATE_TIME :=updatetime; end if;
end if;end select_count_temp;
谢了 T-T 我不会oracle,只会sql server T-T同样是sql 怎么差距就那么大呢 -_-||
就是elsif。
先刨除语法的问题。是不是你写的触发器逻辑和你描述的也不一样呀!