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
What do you mean by database?
sparse lookup and where its options we find in OCI and db2?
How does non-cluster index functions?
What are different types of blocks used in stored procedure?
Does facebook use graph database?
What is the function of cluster index?
What is Object Oriented model?
Explain transaction manager?
how can you perform lookup range in lookup stage expalin in detail?
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
can u combine pipeline parallelism and partition parallalism? how and whan?
What is the best database?
What are the advantages of views in a database?
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
Explain artificial key?