ProcedureFunction (Difference)

{\rtf1\ansi\ansicpg1252\deff0\deflang16393{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Calibri;}}
{\stylesheet{ Normal;}{\s1 heading 1;}}
{\*\generator Msftedit 5.41.21.2509;}\viewkind4\uc1\pard\keepn\s1\li720\lang1033\b\f0\fs18 Procedure \par
\pard\b0\par
\pard\li1440 A procedure is a subprogram that performs a specific action\par
Procedure Does and Does not return the Value.\par
Procedure we can use (In, Out, InOut Parameter)\par
You cannot use the procedure in select Statement.\par
\pard\fi720\li720 Execute as a PL/SQL statement\par
\pard\li1440 No RETURN clause in the header\par
\pard\fi720\li720 Can return none, one, or many values\par
\pard\par
\pard\keepn\s1\li720\b Function\par
\pard\b0\par
\pard\fi720\li720 A function is a subprogram that computes a value\par
Invoke as part of an expression\par
Must contain a RETURN clause in the header\par
Must return a single value\par
Must contain at least one RETURN statement\par
\pard\li1440 Always return the Value.\par
Function you cannot use the (In, Out, InOut Parameter)\par
\pard\sa200\sl276\slmult1 You can use the Function the in select Statement.\lang9\f1\fs22\par
}