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;

21 comments:

SUMIT KUMAR GUPTA 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

Himanshu Joshi 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

Dipanwita said...

This is a great blog. Keep it up. java training in chennai

johnsy sai 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

Chitra devi said...


This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.. 

best rpa training in chennai |
rpa training in chennai | rpa online training |
rpa training in chennai |
rpa training in bangalore
rpa training in pune
rpa training in marathahalli
rpa training in btm

Saro said...

Inspiring writings and I greatly admired what you have to say , I hope you continue to provide new ideas for us all and greetings success always for you..Keep update more information.

best rpa training in chennai
rpa training in chennai |
rpa online training
rpa course in bangalore
rpa training in pune
rpa training in marathahalli
rpa training in btm

kevin john said...

Inspiring writings and I greatly admired what you have to say , I hope you continue to provide new ideas for us all and greetings success always for you..Keep update more information.

best rpa training in chennai
rpa training in chennai |
rpa online training
rpa course in bangalore
rpa training in pune
rpa training in marathahalli
rpa training in btm

Mouni yoga 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

jeeva said...

This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.

best rpa training in chennai
rpa training in chennai |
rpa online training
rpa course in bangalore
rpa training in pune
rpa interview questions and answers | blueprism interview questions and answers

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

Nila shri said...

I found this informative and interesting blog so i think so its very useful and knowledge able.I would like to thank you for the efforts you have made in writing this article.
Data Science training in Chennai | Data Science Training Institute in Chennai
Data science training in Bangalore | Data Science Training institute in Bangalore
Data science training in pune | Data Science training institute in Pune
Data science online training | online Data Science certification Training-Gangboard
Data Science Interview questions and answers


keith kristoper said...

I am really happy with your blog because your article is very unique and powerful for new reader.
Click here:
selenium training in chennai
selenium training in bangalore
selenium training in Pune
selenium training in pune
Selenium Online Training

ijazz jazz said...

Does your blog have a contact page? I’m having problems locating it but, I’d like to shoot you an email. I’ve got some recommendations for your blog you might be interested in hearing.


AWS Training in Pune | Best Amazon Web Services Training in Pune

AWS Tutorial |Learn Amazon Web Services Tutorials |AWS Tutorial For Beginners

Amazon Web Services Training in OMR , Chennai | Best AWS Training in OMR,Chennai


AWS Training in Chennai |Best Amazon Web Services Training in Chennai


Amazon Web Services Training in Pune | Best AWS 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

Xplore IT Corp said...

Hey Nice Blog!! Thanks For Sharing!!!Wonderful blog & good post.Its really helpful for me, waiting for a more new post. Keep Blogging!
dot net course training in coimbatore
Embedded systems training in coimbatore

ajay prakash said...

Such an excellent and interesting blog, Do post like this more with more information, This was very useful, Thank you.
Aviation Academy in Chennai
Aviation Courses in Chennai
best aviation academy in chennai
aviation institute in chennai

Unknown said...

Thanks