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

Explain entity ?

614


What is the concept of Virtual field?

1636


Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar

1596


How to do Data size testing? Who does this testing (Developer or tester)?

2139


What are database connection details?

658






can u combine pipeline parallelism and partition parallalism? how and whan?

1896


What is a reference table in database?

585


how to configure oracle 10g in java1.5 and tell me know how to set class path in system?

1601


what is tkprof tool and how it is used???

2391


Explain file manager?

630


Can you create a database in word?

544


Explain data independence & its types.

607


How to produce such kind of file?

650


Explain normalization in one line?

650


What is database server and how it works?

567