Oracle PL-SQL Interview Question:

What is difference between a PROCEDURE & FUNCTION?

Submitted by: Administrator

A FUNCTION is always returns a value using the return statement.
A PROCEDURE may return one or more values through parameters or may not return at all.
Submitted by: Administrator

Function:
1) should return value ,
2) used in both sql and plsql

Procedure :
1) may or may not return value ,
2) only used in plsql .
Submitted by: Nithya S