How to calculate EMI using PLSQL Code :: Oracle PLSQL :: Loan EMI Calculation :: Tutorial in Telugu

How to calculate Loan EMI amount using PLSQL Code. This Video explains the step by step process of building code to calculate the EMI amount using PLSQL Code. If you find this video is useful then please LIKE, SHARE. Please leave your valuable opinion as comments and Subscribe to our channel. SQL Videos Playlist: https://www.youtube.com/playlist?list=PLLbO25aU27gr96LH9Np5dN1aH0XyMYUeB PLSQL Videos Playlist: https://www.youtube.com/playlist?list=PLLbO25aU27grKJA-3zBSMp7LjkylQpFI6 Excel Videos Playlist: https://www.youtube.com/playlist?list=PLLbO25aU27gq-q_J_27tOmVlz679_SbeQ create or replace NONEDITIONABLE FUNCTION XXEMI_CALCULATOR_FUNC(p_principle NUMBER, p_int_rate NUMBER, --Yearly Rate of Interest p_tenure NUMBER --Years ) RETURN NUMBER AS l_monthly_rate NUMBER; l_months NUMBER; l_EMI NUMBER; BEGIN l_monthly_rate:=(p_int_rate/12)/100; --Monthly Rate of Interest l_months:=p_tenure*12; --Tenure in Months --P x R x (1+R)^N / [(1+R)^N-1] l_EMI:=p_principle*l_monthly_rate*power(1+l_monthly_rate,l_months)/ (power(1+l_monthly_rate,l_months)-1); RETURN ROUND(l_EMI,2); EXCEPTION WHEN OTHERS THEN dbms_output.put_line('Error '||SQLERRM); l_EMI:=0; END;