Answer Posted / jyothsna
2 or more procedures or functions are called overloaded when
a) They have the same names
b) Different no of formal parameters defined
c) Formal parameters differ in their datatypes/Subtypes and
not in the same family
d) They belong to same subprogram/package/PL SQL Block
They are not overloaded when
a) Any of the above points are not satisfied
b) RETURN datatype alone differs and not the formal
parameters
The main purpose of overloading procedures is that, when a
PL SQL block is found to do a same operation with different
inputs, we names them same and feed different parameters
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Does a join table need a primary key?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
what is the use of set statement in tsql? : Transact sql
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What happens when a trigger is associated to a view?
Is vs as in pl sql?
What is rownum?
Differentiate between pl/sql and sql?
How do I remove all records from a table?
Why is sharding used?
How to run sql commands in sql*plus?
how to escape special characters in sql statements? : Sql dba
what are the differences between binary and varbinary? : Sql dba
How to start the command-line sql*plus?
What is meant by truncate in sql?
