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?

  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.

--

--

JavaInhand Tutorial: Get the latest Tutorials About Oracle APEX Tutorial, Oracle APEX Tutorial Video. Go to the below website https://www.javainhand.com

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Javainhand Tutorial

JavaInhand Tutorial: Get the latest Tutorials About Oracle APEX Tutorial, Oracle APEX Tutorial Video. Go to the below website https://www.javainhand.com