will function return more than one value how

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / arpitha2206

9 Answers
21181 Views
Accenture, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

will function return more than one value how..

Answer / murali

Yes. By using Out Parameter we can return morethan one value.

Is This Answer Correct ?

20 Yes

11 No

will function return more than one value how..

Answer / chaitra

A function can return more than one value if the function
is returning a data structure like PL/SQL Table, REF CURSOR
etc.
But returning more than one value by the use of OUT
parameter cannot be done as this fails when the function is
called from an SQL statement ( as in where var = fn(..)).

Is This Answer Correct ?

9 Yes

1 No

will function return more than one value how..

Answer / rahul

To get more then two values from a function use a data
structure like record or VARRYs to get more then one value
from function

Is This Answer Correct ?

6 Yes

1 No

will function return more than one value how..

Answer / t p tripathy

yes function will return more than one value by using ref
cursor.

Is This Answer Correct ?

6 Yes

2 No

will function return more than one value how..

Answer / suresh mallipeddi

using oracle collections like varrays or records function
return more then value

Is This Answer Correct ?

3 Yes

0 No

will function return more than one value how..

Answer / prashant tripathi

yes, function can return more then one value.
murali is write but.... it is not a good progrmming way.

Sakthivel is also write that....function must return one
value.

My Answer :

fucntion can return more then one value but in the if-else
condition. it return one value at a time. but it can return
more than one value.

Is This Answer Correct ?

5 Yes

3 No

will function return more than one value how..

Answer / vikas

Yes,it is possible by creating function table.

Is This Answer Correct ?

1 Yes

0 No

will function return more than one value how..

Answer / bolearner

Can someone give an answer with good example for this question.

Is This Answer Correct ?

0 Yes

0 No

will function return more than one value how..

Answer / sakthivel

NO,we cannot use inout,out parameters in functions. so
function must return one value

Is This Answer Correct ?

7 Yes

27 No

Post New Answer