What is the difference between a `FUNCTION` and a `PROCEDURE` in SQL?

Advanced SQL Developer Medium

Advanced SQL Developer — Medium

What is the difference between a `FUNCTION` and a `PROCEDURE` in SQL?

Key points

  • Functions return a value and can be used in expressions
  • Procedures do not have to return a value and support output parameters
  • Procedures cannot be used directly in SELECT expressions

Ready to go further?

Start full exam Practice more questions

Related questions