Answer / murali

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

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(..)).

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

Answer / t p tripathy

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

Answer / suresh mallipeddi

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

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.

Answer / vikas

Yes,it is possible by creating function table.

Answer / bolearner

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

Answer / sakthivel

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

How can we link a sql database to an existing android app?

0 Answers  

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)

1 Answers   Fidelity, Oracle,

What is procedure explain with example?

0 Answers  

how to check the 3rd max salary from an employee table?

23 Answers   IBM,

How do sql triggers work?

0 Answers  

1. how to use the check option constraints in sql query..? 2.how to add data in a complex query ? 3.is it possible to use commit or rollback or savepoint in triggers...if not why please explain with examples...? 4.what is the difference between meterialized view and normal view..how to create materialized view and how to use it..? 5.what is varray...? what is the advantage of the varray ? please expalin with a simpel example..i want to load into a table (student no and name and his marks..) please give example.. 6.what are the bulk bind exceptions...how to use bulk bind and how to use bulk collect..please explain with example... 7.what is for update of and where current of ...? 8 what is the use of nowait ? 9.please give an example for nocopy in a simple plsql query 10.create an index in a table...tellme how to use the index in a where clause to do performance tunning...

3 Answers   Satyam,

How do I run sql profiler?

0 Answers  

How do you optimize SQL queries ?

6 Answers   CarrizalSoft Technologies, Infosys, Oracle,

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

2 Answers   CG,

how to concatenate two character strings? : Sql dba

0 Answers  

What is the purpose of the partition table?

0 Answers