Can we have a function Overloading with same number of
arguments but with different return types of function

Answers were Sorted based on User's Feedback



Can we have a function Overloading with same number of arguments but with different return types o..

Answer / anupam

No,writing no. of functions with the same name but
different argument is called as function overloading.
The arguments may be differ in nos,type etc.
The return type may or may not be same.

Is This Answer Correct ?    9 Yes 0 No

Can we have a function Overloading with same number of arguments but with different return types o..

Answer / abhilash s thachil

There is a catch in the question. We can have function overloading with same number of arguments with different return types. One step ahead, we can have function overloading with same number of arguments provided the type and order of the arguments are not same irrespective of return type.

Is This Answer Correct ?    6 Yes 0 No

Can we have a function Overloading with same number of arguments but with different return types o..

Answer / sandeep joshi

No its not possible.
Because in function overloading the return type is not play
any role.

Is This Answer Correct ?    6 Yes 3 No

Can we have a function Overloading with same number of arguments but with different return types o..

Answer / vikram shinde

function signature (name mangling) is done based on function
name and no. of parameter.we can't diff. by return type
because when function call there will be ambiguty.

Is This Answer Correct ?    5 Yes 2 No

Can we have a function Overloading with same number of arguments but with different return types o..

Answer / vivek

Generally no but.......... ADA(Language) supports it
..............Source Wikipedia search for polymorph ism

Is This Answer Correct ?    2 Yes 0 No

Can we have a function Overloading with same number of arguments but with different return types o..

Answer / deepika galankar

no . we can have same function name with arguments differ
in number,type and different order of data types . but for
function overloading compiler ignore return type.
so we can have funfions with same no of arguments differ in
sequence of data type irrrespective of return type ..

Is This Answer Correct ?    1 Yes 0 No

Can we have a function Overloading with same number of arguments but with different return types o..

Answer / ajay

Yes, it is possible here are the examples

create or replace function funbool(b varchar2)
return boolean
as
begin
If b is not null then
return true;
else
return false;
end if;
end;

create or replace function funbool(b varchar2)
return number
is
begin
if b is null then
Dbms_output.put_line( 'false');
else
Dbms_output.put_line( 'true');
end if;
Return b;
end;

Is This Answer Correct ?    1 Yes 4 No

Can we have a function Overloading with same number of arguments but with different return types o..

Answer / ajay

Yes

Is This Answer Correct ?    4 Yes 9 No

Post New Answer

More Databases AllOther Interview Questions

What is database collection?

0 Answers  


How does database replication work?

0 Answers  


what are wrappers and build ups and what it's use?

0 Answers   TCS,


what are different types of datasets? what are different characteristics or properties of those datasets? what are the advantages and disadvantages of each dataset on each other?

1 Answers   OVGU,


Explain phantom deadlock?

0 Answers  






Explain about ur projets on teradata???

0 Answers   Wipro,


what is the difference between relational calculus and relational algebra ?

6 Answers   TCS,


Write a query to retrieve for many to many relationships?

0 Answers   CGI,


What is the main difference b/w Teradata and Oracle?

1 Answers   TCS,


Write the major components of a Database Management System?

3 Answers  


i have windows-xp processor with P4 system. whenever I tried to download foxpro for windows 2.6 on windows XP, my operating system failed to install foxpro for windows 2.6.please. how could i download , install & run foxpro for windows 2.6 easily on windows XP ?

0 Answers  


Differentiate between unique key and foreign key?

0 Answers   CGI,


Categories