Saturday 23 July 2016

What is difference between Procedure and Function?

Procedure
Function
A procedure is a subprogram that performs a specific action.
A function is a subprogram that computes a value.
Procedure Does and Does not return the Value
Must return a single value
Procedure we can use (In, Out, InOut Parameter)

Function we can’t use the (In, Out, InOut Parameter)
We can’t use the procedure in select Statement
We can use the Function the in select statement.
Execute as a PL/SQL statement
Invoke as part of an expression
No RETURN clause in the header
Must contain a RETURN clause in the header
Can return none, one, or many values.
Must contain at least one RETURN statement. Always return the Value.

No comments:

Post a Comment