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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How heap is implemented in database?

855


what is data access layer?

2128


Which three commands cause a transaction to end?

764


What is the purpose of TNS?

792


Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.

2284


How to produce such kind of file?

849


What is table scan and index scan?

813


What is the Lock Based Protocol used for?

822


Should I store images in database?

770


Is redis in memory database?

711


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

1936


What is the DIF format and when we will use in teradata

2262


How do I setup a database connection?

721


What is difference between data and database?

747


Which is the best graph database?

696