oracle触发器

[橄榄丝]

如何将一下MS SQLSERVER 2000的触发器改为oracle10：

create trigger visits_update on dbo.Visits 
for update 
as
update visits
set V_DayVisits=case when d.V_DayVisits>i.V_DayVisits then d.V_DayVisits else i.V_DayVisits end,
    V_TotalVisits=case when d.V_TotalVisits>i.V_TotalVisits then d.V_TotalVisits else i.V_TotalVisits end 
from visits a ,inserted i,deleted d
where a.id=i.id and i.id=d.id

GO

[gelyon]

create or replace trigger visits_update 
before update on dbo.Visits
for each row
begin
    if :old.V_DayVisits>:new.V_DayVisits then
       :NEW.V_DayVisits:=:old.V_DayVisits;
    end if ;
    if :OLD.V_TotalVisits>:NEW.V_TotalVisits then
       :NEW.V_TotalVisits:=:OLD.V_TotalVisits;
    end if ;    
end;

[真的不知道取什么名]

create or replace trigger visits_update 
before update on dbo.Visits
for each row
begin 
update visits a
set V_DayVisits=(case when :old.V_DayVisits>:new.V_DayVisits 
                 then :old.V_DayVisits else :new.V_DayVisits end),
    V_TotalVisits=(case when :old.V_TotalVisits>:new.V_TotalVisits 
                   then :old.V_TotalVisits else :new.V_TotalVisits end)
where a.id=:new.id and :new.id=:old.id;

[心中的彩虹]

[Quote=引用楼主 gaozhi0 的回复:]
如何将一下MS SQLSERVER 2000的触发器改为oracle10：

SQL code

create trigger visits_update on dbo.Visits
for update
as
update visits
set V_DayVisits=case when d.V_DayVisits>i.V_DayVisits then d.V_DayVisi……
[/Quote]

create or replace trigger tri_tb_up before update on Visits for each row
begin
select 
decode(sign(:new.V_DayVisits-:old.V_DayVisits),1,:new.V_DayVisits,-1,:old.V_DayVisits),
decode(sign(:new.V_TotalVisits-:old.V_TotalVisits),1,:new.V_TotalVisits,-1,:old.V_TotalVisits) into :new.V_DayVisits,:new.V_TotalVisits from dual;
end;

[delphisanding1]

好的
学习了