Question: what is the difference between procedures and functions in oracle?
Answer: The difference is- A function must return a value (of any type) by default definition of it, whereas in case of a procedure you need to use parameters like OUT or IN OUT parameters to get the results. ... Functions are normally used for computations where as procedures are normally used for executing business logic.