| Procedure A Procedure is a subprogram that performs a specific actionProcedure Does and Does not return the Value.Procedure we can use (In, Out, InOut Parameter)You cannot use the procedure in Select Statement.Execute as a PL/SQL statementNo RETURN clause in the headerCan return none, one, or many values FunctionA Function is a subprogram that computes a valueInvoke as part of an expressionMust contain a RETURN clause in the headerMust return a single valueMust contain at least one RETURN statementAlways return the Value.Function you cannot use the (In, Out, InOut Parameter)You can use the Function the in Select Statement. |
