Click here to Skip to main content
15,881,852 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL
create table SITABLE5(prin_amt number(10,2),no_year number(10,2),rate_in number(10,2),si number(10,2),ci number(10,2));
desc SITABLE5;
SELECT * FROM SITABLE5;
 
DECLARE
p number(10,2);
n number(10,2);
r number(10,2);
a number(10,2);
b number(10,2);
i number(2);
n1 number(10);
c number(10,2);
s number(10,2);
FUNCTION sif(p2 in number,n2 in number,r2 in number)
RETURN number
is
c number;
begin
c:=p2*n2*r2/100;
RETURN C;
end sif;
 
FUNCTION cif(p3 in number,n3 in number,r3 in number)
RETURN number
is
d number;
begin
d:=p3*(1+r/100)*n;
RETURN D;
end cif;
 
BEGIN
n1:=&no_of_records;
i:=1;
LOOP
if i<=n1 then
p:=&p;
n:=&n;
r:=&r;
insert into SITABLE5(prin_amt,no_year,rate_in) VALUES(p,n,r);
a:=sif(p,n,r);
b:=cif(p,n,r);
update SITABLE5 set si=a;
update SITABLE5 set ci=b;
i:=i+1; 
end if;
end loop;
END;

select * from SITABLE5;
Posted
Updated 4-Feb-15 21:40pm
v4

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900