Join Our Email Alerts-Subscribe
Important Note:Login & Check Your Email Inbox and Activate Confirmation Link



Enter Your Email :

Copyright Disclaimer:
Section 107 of the Copyright Act Fair Use Contents .
We are forwarding content link(s) from our website to content website & We are not serving any contents.
Main Source:Google.com.All the Content PDF link(s) is/are obtained from GoogleSearch
for the purpose of Education & Teaching Intention. Not for commercial purpose.
Technicalsymposium.com is not liable/responsible for any copyright issues.

DBMS Programming Source Codes & Study Notes-Free Download



Free Download of All Study Materials & ebooks PDF-Click & Download



PL SQL Program For EB AMOUNT CALCULATION.

create or replace trigger calc After insert or update or delete on EBFIRST for each row
declare
unit number(3);
amt number(8,3);
begin
if inserting then
unit:=:new.cur-:new.prev;
if(unit>=500) then amt:=unit*5;
elsif(unit>=400) then amt:=unit*4;
elsif(unit>=300) then amt:=unit*3;
elsif(unit>50) then amt:=unit*2;
else amt:=50;
end if;
insert into ebsecond values(:new.cusno,:new.name,unit,amt);
dbms_output.put_line(:new.cusno||' '||:new.name||' '||unit||' '||amt);
dbms_output.put_line('amt calculated and records inserted');
end if;
if updating then
unit:=:new.cur-:new.prev;
amt:=unit*2.5;
update ebsecond set units=unit,amount=amt
where cusno=:old.cusno;
dbms_output.put_line(:old.cusno||' '||:old.name||' '||unit||' '||amt);
dbms_output.put_line('amt calculated and records updated');
end if;
if deleting then
delete from ebsecond where cusno=:old.cusno;
dbms_output.put_line(' Record '|| :old.cusno ||' deleted successfully');
end if;
end;


Technicalsymposium.com-Free Study Materials PDF-Download




Technicalsymposium.com-Download All Study Notes PDF




Technicalsymposium.com-Free Live Support-Chat with Our Experts

Official Contact: +91-9245556793 (Whatsapp Message / SMS / Voice Call)


Our Expert team is ready to answer all your questions immediately-Feel free to speak in Tamil/English.

(Example:Events info/Lecture Notes/Off-Campus & All Jobs/Projects & All education information)

Working hrs (IST): (Morning: 10:00AM-3:00 PM) and (Evening:5:00 PM to 10:00 PM)

All Latest Question & Answer Page (FAQ)-Click here