What is difference between a PROCEDURE & FUNCTION ?
Answers were Sorted based on User's Feedback
Answer / anil kumar jampana
sorry, we can use in,inout,out parameters in functions also.
one more diff. we can use functions in normal sql queries
but we cann't use procedures in sql queries....
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / ace
A function is a special kind of procedure. A function
returns a value in its name. A function can return more
than one value if it returns a ref cursor.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / naresh bs
The main difference is that, a procedure may return and
value but a function has to return a value.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / pankaj mehra
Well the main difference between procedures and function is
that the procedure may/may not return any value.it can
return more than one value also.
but functions can return only one value at a time and it
must have return keyword inside the function
Is This Answer Correct ? | 3 Yes | 4 No |
Answer / surajit pathak
We can use in,inout,out parameters in functions also.
The most important difference is we can use functions in
normal sql queries if it is not containing any out
parameters.
but we cann't use procedures in sql queries....
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / chandrasekar.ramasamy
Function accepts only in parameter but procedure accepts
in,out and inout
Function mostly used for mathamatical calculations
But procedure used to execute business logics
Is This Answer Correct ? | 0 Yes | 11 No |
What is a natural join sql?
differentiate between float and double. : Sql dba
What is Temp Table and type of temp table?
Cite the differences between execution of triggers and stored procedures?
Is there any restriction on the use of union in embedded sql?
What is sql profiling in oracle?
Why do we need unique key in a table?
What type of database is cloud sql?
what are enums used for in mysql? : Sql dba
Are sql database names case sensitive?
What is the usage of the distinct keyword?
What is a database link?