Difference between Procedure and Function?
- Function must return a value and procedure need not.
- Function can be used in SQL queries with some restrictions. Procedure cannot be called directly from SQL query.
You can watch this video tutorial for more clarifications on Procedures and Functions.
