| |
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. |
| September 09, 2006 07:09:21 |
#5 |
| Mrunal |
Member Since: Visitor Total Comments: N/A |
RE: Difference between procedure and function.
|
One more difference is Procedure can executed by writing exec(Procedure_name), But Functions are called in DML statements or a PL/SQL Block. |
| |
Back To Question | |
