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 the largest value that can be stored in a byte data field?
How do I make sql search faster?
Is join same as left join?
Write a sql query to get the third highest salary of an employee from employee_table?
Why is the cursor important?
Is it important to partition hard disk?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What is the use of pl/sql table?
how to write date and time literals? : Sql dba
what is the use of friend function? : Sql dba
How to call shell script from pl sql procedure?
What is the difference between in and between in sql?
Who developed sql?
What is dml with example?
How to display the current date in sql?
