SQL> create table tbltes(id number(5)); SQL> create or replace trigger trgtest 2 before update 3 on tbltest 4 for each row 5 declare 6 lv number(3); 7 begin 8 if :new.id=1 then 9 :new.id :=10; 10 elsif :new.id=2 then 11 :new.id :=20; 12 end if; 13 end; 14 /
create or replace trigger TestSeq_Trigger before update on TestSeq for each row declare next_id number; begin next_id=4; new.tid := next_id; end;
SQL> create or replace trigger trgtest
2 before update
3 on tbltest
4 for each row
5 declare
6 lv number(3);
7 begin
8 if :new.id=1 then
9 :new.id :=10;
10 elsif :new.id=2 then
11 :new.id :=20;
12 end if;
13 end;
14 /
before update on TestSeq for each row
declare
next_id number;
begin
next_id=4;
new.tid := next_id;
end;