Difference Between Function and Procedure in Oracle PL/SQL

In this Tutorial, We will explore the Difference Between Function and Procedure in PL/SQL.

What is Difference Between Function and Procedure in Oracle PL/SQL?

Function:-

1. Function must always return a value.
2. Function can be used in SQL statement.
3. Function used for computational purpose.

Procedure:-

1. Procedure can not return value but using IN and INOUT parameter procedure can return the value.
2. We can not run procedure in SQL statement.
3. Procedure is basically use for the bussiness logic.

That’s all for today, I hope this (Difference Between Function and Procedure in Oracle PL/SQL) post will be helpful for you. If you like the post then share your view in the comment box.