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

what are the differences between require and include, include_once and require_once? : Sql dba

0 Answers  

what is the bond code in materialized view?

0 Answers  

wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure

3 Answers   Apollo,

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

0 Answers  

State the advatage and disadvantage of Cursor's?

2 Answers  

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

Can we rename a column in the output of sql query?

0 Answers  

How to add a column ‘salary’ to a table employee_details?

0 Answers  

Which is faster subquery or join?

0 Answers  

What is difference between a PROCEDURE & FUNCTION ?

6 Answers   Satyam,

What is the difference between an inner join and an outer join?

0 Answers