create or replace trigger insert_Or_update
before insert or update on t
for each row
begin
if (t.title = '副教授' )then
set t.title := '教授'
end if;
end;
如果插入和更新操作中有title为副教授的,改为教授
错在哪里?谢谢了
before insert or update on t
for each row
begin
if (t.title = '副教授' )then
set t.title := '教授'
end if;
end;
如果插入和更新操作中有title为副教授的,改为教授
错在哪里?谢谢了
before insert or update on t
for each row
begin
if (:new.title = '副教授' )then
set :new.title := '教授'
end if;
end;
瞎寫,不知道對不對
before insert or update on t
for each row
begin
if (:new.cnname = '副教授' )then
:new.cnname := '教授';
end if;
end;
这样就可以了;
create trigger teacher
before insert or update
on t
referencing old as old_value
new as new_value
for each row
when (new_value.title='副教授' )
begin
:new_value.title :='教授';
end;
/