Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between Procedure and Function

950968Aug 25 2012 — edited Aug 25 2012
Hi Experts,
My Question is regarding difference between Procedure and Function.We Know that Procedure is Basically Used to perform Actions and Functions are Basically Used for Calculations but what would be the exact difference since Actions/Calculations can be done in both Procedure and Functions.Which factors decide whether we need to write a Prcoedure and in which cases we need Function.Asked in an Interview.Please explain.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2012
Added on Aug 25 2012
4 comments
238 views