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
Explain inner and outer joins with examples.
How do I manually create a database?
Differentiate between delete and truncate table?
Explain database partitioning. What is its importance?
What is difference between data and database?
What is a database call?
What is a driver in database?
How many types of normalization? What is the use of it?
What is database bounce?
Is redis in memory database?
Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it
What is Data Modelling?
There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?
What is dialect in database?
How default key is different from primary key?