Program to find Simple Interest and Compound Interest in PL/SQL
Prerequisite
Examples:
Input: p = 1500 r = 5 t = 3 Output: SI = 225, CI = 1736.44 Input: p = 2700 r = 7 t = 8 Output: SI = 1512, CI = 4639.1
Formula for Simple Interest:
Formula for Compound Interest:
Where:
Below is the required implementation:-
DECLARE --declaration of principal variable p NUMBER(9, 2); ----declaration of rate variable r NUMBER(9, 2); --declaration of time period variable t NUMBER(9, 2); --declaration of simple interest variable si NUMBER(9, 2); ci NUMBER(9, 2); BEGIN --Code Block Start --assigning principal values p := 33000; --assigning rate values r := 7; --assigning time period values t := 6; --To calculate SI by simple --mathematical formula si := ( p * r * t ) / 100; ci := p * Power (1 + ( r / 100 ),t); --Print Result of SI......... dbms_output.Put_line( 'Simple Interest = ' ||si); dbms_output.Put_line( 'Compound interest = ' || ci); END ; --End program |
Output
Simple Interest = 13860 Compound interest = 49524.1