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
How heap is implemented in database?
what is data access layer?
Which three commands cause a transaction to end?
What is the purpose of TNS?
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
How to produce such kind of file?
What is table scan and index scan?
What is the Lock Based Protocol used for?
Should I store images in database?
Is redis in memory database?
can we delete autodiff back up that we have set through sql server agent.
What is the DIF format and when we will use in teradata
How do I setup a database connection?
What is difference between data and database?
Which is the best graph database?