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 |
How can you create Cursor with parametres ?
What does truncate mean in sql?
What is the order of sql select?
Does sql require a server?
Where do we use pl sql?
Does pl/sql support create command?
If we update a complex view, is base table will get update ?
2 Answers Ardee Technologies, HCL,
what is innodb? : Sql dba
What is sql and also describe types of sql statements?
Is clustered index a primary key?
How do I trace sql profiler?
What is the process of debugging?