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 nested table in word?
what is self join and what is the requirement of self join? : Sql dba
what are ddl statements in mysql? : Sql dba
what is the difference between delete and truncate statement in sql? : Sql dba
What is nvarchar max in sql?
What are actual parameters and formal parameters?
What are properties of the transaction?
What are the different dml commands in sql?
what are date and time intervals? : Sql dba
Is sql procedural language?
How to return an array from java to pl/sql?
what are the types of subquery? : Sql dba
What are aggregate and scalar functions?
how to analyze tables with 'mysqlcheck'? : Sql dba
how to use like conditions? : Sql dba
