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 valuesFunctionA 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.
