In PL/SQL,a function is used instead of a procedure when:
A) You want to manipulate output variables.
B) You want to produce a side effect.
C) You are returning a single value.
D) You want to return more than one result.

Question

Quizplus · Accepted Answer

Functions are used in PL/SQL when a single value needs to be returned whereas procedures are used when we need to manipulate output variables or want to produce a side effect. Functions cannot return more than one result.

In PL/SQL,a Function Is Used Instead of a Procedure When