| Function | Procedure |
Return of value | Always returns a value. | May or may not return a value. |
Tasks performed | Function performs a specific task. | A procedure may perform multiple tasks. |
Calling from SQL statements | Such calling is possible for functions. | Such calling isn’t feasible for procedures. |
Use | Functions are typically used to perform computations. | Procedures are used to execute business logic. |
Independent execution | A function doesn’t execute independently. It has to be a part of the executable statement. | A procedure itself represents an executable statement, so it can run independently. |