Home » PL/SQL MCQs

What is the difference between PL/SQL Function and PL/SQL Procedure?

64. What is the difference between PL/SQL Function and PL/SQL Procedure?

1. PL/SQL function may or may not return the value whereas PL/SQL Procedure must have to return the value.
2. PL/SQL Procedure may or may not return the value whereas PL/SQL Function must have to return the value.
3. PL/SQL Function may or may not return the function whereas PL/SQL Procedure must have to return the function.
4. None of the above

Answer: B) PL/SQL Procedure may or may not return the value whereas PL/SQL Function must have to return the value

Explanation:

PL/SQL Procedure may or may not return the value whereas PL/SQL Function must have to return the value.