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;