Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is a constraint? Tell me about its various levels.
Is sql scripting language?
Why stored procedure is faster than query?
How many parts of a pl sql block are optional?
How does pl sql work?
what are the differences between char and varchar? : Sql dba
How will you distinguish a global variable with a local variable in pl/sql?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is cursor and its types?
How do I view stored procedures?
How do I partition in sql?
What is a scalar value in sql?
What is sql and also describe types of sql statements?
What is microsoft t sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
