Created
January 18, 2017 17:53
-
-
Save amalaugustinejose/68cae803e545f0d62433103d8dd40b03 to your computer and use it in GitHub Desktop.
Fail Trigger, MACE
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create table mark (sid number(5) primary key, m1 number(3), m2 number(3), m3 number(3)); | |
create table fail (sid number(5) primary key, m1 number(3), m2 number(3), m3 number(3)); | |
create or replace trigger failtrigger | |
before insert on mark | |
for each row | |
declare | |
v_total number(3); | |
begin | |
v_total := :new.m1 + :new.m2 + :new.m3; | |
if (v_total < 120) then | |
insert into fail values(:new.sid, :new.m1, :new.m2, :new.m3); | |
end if; | |
end; | |
/ | |
insert into mark values (1, 50, 50, 50); | |
insert into mark values (2, 39, 39, 39); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment