| |
GeekInterview.com > Interview Questions > Oracle > SQL
| Print | |
| Question: Difference between procedure and function.
Answer:
Functions are named PL/SQL blocks that return a value and can be called with arguments procedure a named block that can be called with parameter. A procedure all is a PL/SQL statement by itself, while a Function call is called as part of an expression. |
| August 08, 2006 06:45:43 |
#4 |
| SHIKHA |
Member Since: Visitor Total Comments: N/A |
RE: Difference between procedure and function. |
One more diff is that function must return a value while procedure may or may not return a value |
| |
Back To Question | |