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 |
Wat is SGA ?
What are stored procedures used for?
What is the difference between microsoft access and sql?
why use cursors?
What is the default value of CHAR type?
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance
Why are aggregate functions called so?
What is a join?Explain the different types of joins?
6 Answers Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS,
How do you delete duplicates in sql query using rowid?
What are different types of joins ?
Is a foreign key always unique?
What is a constraint? Tell me about its various levels.