What is Overloading of procedures ?
Answers were Sorted based on User's Feedback
Answer / madhuri
You can use the same name for different procedures if their
formal parameters differ in number, order, or data type family.
Is This Answer Correct ? | 12 Yes | 1 No |
Answer / swapna
Overloading procs are 2 or more procs with the same name
but different arguments.
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / yalamanda
by using the same name we can write any no.of
procedures/functions in a package.but either no.of
parameters in the procedure/function must be varry or
parameter datatype must be varry
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
What is sql*loader?
Can we use view in stored procedure?
How to avoid duplicate records in a query?
Where is sql database stored?
What are the differences between Database Trigger and Integrity constraints ?
Is sql considered coding?
What is implicit cursor in pl sql?
Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL
what is global table
What is a procedure in pl sql?
What are the types of dbms?
Can we use distinct and group by together?