Question { IBM, 99778 }

What is difference between function and procedure?

Answer

1.Function always return a single value but procedure may
return more than one value.
2.We can use functions in select statement but we can not
use procedure in select statement.
3.There is possible of recurssive functionlike max(min
(something)),but there is nothing like in procedure.
4.In function we use a return keyword but in procedure no
return keyword is used.