top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

When do use we procedure or function in oracle?

+5 votes
When do use we procedure or function in oracle?
posted Feb 5, 2014 by Prasad

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Functions are generally restricted to returning a single value, while procedures can have multiple OUT parameters. There are situations where functions are more useful in queries (i.e. you want to create your own function that can be used in a query like the standard functions UPPER, etc.). In some client-side languages, it's slightly easier to call stored procedures rather than stored functions.

But I am not sure what you are looking for, could you please be specific...

answer Feb 5, 2014 by Majula Joshi
Contact Us
+91 9880187415
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Karnataka INDIA.