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

select sal from emp group by sal

3 Answers   TCS,

---

Enlist the advantages of sql.

0 Answers  

---

how to calculate the difference between two dates? : Sql dba

0 Answers  

---

Is truncate ddl or dml?

0 Answers  

---

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

---

what is the difference between nested subquery and correlated subquery?

0 Answers  

---

What is the use of non clustered index?

0 Answers  

---

Why is there a need for sqlcode and sqlerrm variables?

0 Answers  

---

What is a table partition?

0 Answers  

---

Can we create table inside stored procedure?

0 Answers  

---

What is a bitmap index?

4 Answers   Choice Solutions, Infosys,

---

Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

3 Answers   eBay,

---