Answer / madhuri

You can use the same name for different procedures if their
formal parameters differ in number, order, or data type family.

Answer / swapna

Overloading procs are 2 or more procs with the same name
but different arguments.

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

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

What is PL/SQL table ?

6 Answers  

---

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---

List the ways to get the count of records in a table?

0 Answers  

---

Explain what is a field in a database and record in a database?

0 Answers  

---

What is the result, when NULL is compared with NULL?

22 Answers   TCS,

---

---

what is 'trigger' in sql? : Sql dba

0 Answers  

---

Can procedure in a package be overloaded?

1 Answers   HCL,

---

What are the differences between in and exists clause?

0 Answers  

---

How can I pass the inner procedure value to outer procedure ?

2 Answers  

---

I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....

3 Answers  

---

What is the non-clustered index in sql?

0 Answers  

---

How do I count records in sql?

0 Answers  

---