Tuesday, October 21, 2014

Write a PL/SQL program to calculate the simple interest



DECLARE
P NUMBER;
R NUMBER;
T NUMBER;
SI NUMBER;
BEGIN
P := &PRINCIPAL;
R := &RATE;
T := &TIME;
SI := (P * R * T)/100;
DBMS_OUTPUT.PUT_LINE(‘INTEREST ‘ || SI);
END;

12 comments:

Sumit Kumar Software Developer said...

nice post thank you for sharing

Kale Co Jakim said...

Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a Front end developer learn from Javascript Training in Chennai . or learn thru Javascript Training in Chennai. Nowadays JavaScript has tons of job opportunities on various vertical industry. JavaScript Training in Chennai

Unknown said...

Can you give the query for simple interest using function.

blackkutty said...

pleasant post thank you for sharing.

Article Submission sites|Latest Updates| Technology

Sakthi Murugan said...

Thanks for sharing this interesting blog with us.My pleasure to being here on your blog..I wanna come beck here for new post from your site.
Best JAVA Training institute in Chennai
Java Courses in Chennai

Sumaya Manzoor said...

Your website is very cool and it is a wonderful inspiring article. thank you so much.
DOT NET Course Chennai
DOT NET Training Institute in Chennai

gowsalya said...

Thanks for the informative article. This is one of the best resources I have found in quite some time. Nicely written and great info. I really cannot thank you enough for sharing.
advanced excel training in bangalore

Mounika said...

This is a nice article here with some useful tips for those who are not used-to comment that frequently. Thanks for this helpful information I agree with all points you have given to us. I will follow all of them.
python course in pune | python course in chennai | python course in Bangalore

afiah b said...

Really you have done great job,There are may person searching about that now they will find enough resources by your post
Java training in Chennai | Java training institute in Chennai | Java course in Chennai

Java training in Bangalore | Java training institute in Bangalore | Java course in Bangalore

Java online training | Java Certification Online course-Gangboard

Java training in Pune

sathya shri said...

This is a nice post in an interesting line of content.Thanks for sharing this article, great way of bring this topic to discussion.

aws Training in indira nagar

selenium Training in indira nagar

python Training in indira nagar

datascience Training in indira nagar

devops Training in indira nagar

j said...

cool blogg gretings from
https://anothertimebooks.com/

jenani said...

Thanks for posting this! I searched on google and this page was the first result, very good to know.It's Pleasant to Visit your site, Such a Informative Articles Are Really Interesting.Keep Blogging...
Java Training in Chennai

Java Training in Velachery

Java Training in Tambaram

Java Training in Porur

Java Training in OMR

Java Training in Annanagar