create or replace trigger monthreport
after insert on bponderation
for each row
declare
begin
delete from bmonth
where bmonth.fmonth=to_char(sysdate,'mm');
end你的declare多此一舉
取消就可以
create or replace trigger monthreport
after insert on bponderation
for each row
begin
delete from bmonth
where bmonth.fmonth=to_char(sysdate,'mm');
end
after insert on bponderation
for each row
declare
begin
delete from bmonth
where bmonth.fmonth=to_char(sysdate,'mm');
end你的declare多此一舉
取消就可以
create or replace trigger monthreport
after insert on bponderation
for each row
begin
delete from bmonth
where bmonth.fmonth=to_char(sysdate,'mm');
end
create or replace trigger monthreport
after insert on bponderation
for each row
begin
delete from bmonth
where bmonth.fmonth=to_char(sysdate,'mm');
end;--加上分号应该没有问题了
总是提示
为什么总时提示 ‘ora-04079 无效的触发器说明’
Cause: The create TRIGGER statement is invalid.
Action: Check the statement for correct syntax.