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
i have some prob lem to tell me about my self in interview first round ...
Can you have a foreign key without a primary key?
How long it takes to learn pl sql?
Explain the difference between drop and truncate commands in sql?
What does sql stand for?
How can check sql version from command line?
What is the difference between unique and primary key constraints?
What is difference between nchar and nvarchar?
Explain what is rdbms?
what is 'mysqldump'? : Sql dba
How do you declare a constant?
How to avoid using cursors?
What are the popular database management systems in the it industry?
What are the different types of a subquery?
Compare sql & pl/sql
