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.
|
Saturday, 23 July 2016
What is difference between Procedure and Function?
Labels:
PLSQL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment