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
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 |
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 |
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 |
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 |
Answer / vivek
Generally no but.......... ADA(Language) supports it
..............Source Wikipedia search for polymorph ism
| Is This Answer Correct ? | 2 Yes | 0 No |
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 |
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 |
List various types of log-based recovery in DBMS.
What is the Difference Primary key and Unique Key
What are the concurrency problems a database faces?
WHAT IS OPM?(IN DETAILED)
List the properties of a transaction.
Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it
What are different types of data models available? Explain with example?
Is it possible to update AS400 database record while reading it with no lock
What is the difference between a stored procedure and a query?
What is database schema name?
What is the relationship that exists inside in E-R diagram?
Explain entity set?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)