| |
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. |
| April 04, 2007 14:38:46 |
#9 |
| irinak |
Member Since: December 2006 Total Comments: 3 |
RE: Difference between procedure and function.
|
Procedure does not return a Value , but a Funtion return a Value.
SCOTT@LSC01> create or replace type tn is table of number;
2 /
Type created.
SCOTT@LSC01> create or replace function f return tn pipelined is begin null; end;
2 /
Function created.
SCOTT@LSC01> select * from table(f);
no rows selected |
| |
Back To Question | |
