function can return value ,procedure also return value through out parameter t

function can return value ,procedure also return value through
out parameter then what is the difference?

Question Posted / gavini srikanth

3 Answers
6688 Views
3i Infotech, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

function can return value ,procedure also return value through out parameter then what is the diff..

Answer / dinakar

Though a procedure returns a value through OUT parameter,
it cannot be used in a SELECT statement. Whereas a function
can be used in a SELECT statement.

Is This Answer Correct ?

10 Yes

1 No

function can return value ,procedure also return value through out parameter then what is the diff..

Answer / veena

We can use function in select statement but we can't use
procedure in select statement.

Is This Answer Correct ?

1 Yes

0 No

function can return value ,procedure also return value through out parameter then what is the diff..

Answer / damodharan

function should always return only one value
but procedure may return a value value it may one or more
than one value

Is This Answer Correct ?

1 Yes

0 No

Post New Answer