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
Which database is best to store images?
What is lagging in DBMS ?
Explain database partitioning. What is its importance?
What is the difference between primary and candidate key?
HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?
Explain entity type?
What are different types of data models available? Explain with example?
WHAT IS CARDINALITIES OF JOIN?
Explain entity set?
What is the candidate key used for?
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
Does facebook use graph database?
What is Data Modelling?