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.

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.

Answer / sandeep joshi

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

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.

Answer / vivek

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

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

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;

Answer / ajay

Yes

can any one explain about normalization forms with clear explanation in interview point of view. thanks for ur answers.

1 Answers  

can we delete autodiff back up that we have set through sql server agent.

0 Answers   Indian Web Technology,

What advantages does DBMS have over traditional file systems?

0 Answers   ABB, Infogain,

Under which circumstance should you create an index on a table?

0 Answers   3i Infotech,

What is database and its types?

0 Answers  

can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

0 Answers  

Which is the best sorting method if i have to sort the students of Harvard University according to their first name?

1 Answers   CybAge,

Which is the best graph database?

0 Answers  

In TeraData We have 5 SQL queries, without using BTEQ how can we execute those queries?

1 Answers   CTS,

Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.

0 Answers   Amazon,

CLI stands for?

3 Answers   IBM,

where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it

0 Answers