What is the difference between a procedure and function?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is the difference between a procedure and function?
Rating:
The following table describes the difference between a procedure and function:
| A procedure is executed as a PL/SQL statement. | A function is invoked as part of an expression. |
| A procedure does not contain a RETURN clause in its header. | A function must contain a RETURN clause in its header. |
| A procedure can return none, one, or many values to its calling environment. | A function must return a single value to its calling environment. |
| A procedure can contain a RETURN statement in its executable section. | A function must contain at least one RETURN statement in its executable section. |
Rating:
Was this information helpful?
Other articles
- What are the development steps for creating a procedure?
- How is a SQL statement executed?
- What is a statement trigger?
- What is a subprogram?
- What is the signature mode of remote dependency?