What is Overloading of procedures ?

Answers were Sorted based on User's Feedback



What is Overloading of procedures ?..

Answer / madhuri

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

Is This Answer Correct ?    12 Yes 1 No

What is Overloading of procedures ?..

Answer / swapna

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

Is This Answer Correct ?    6 Yes 2 No

What is Overloading of procedures ?..

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

Is This Answer Correct ?    0 Yes 0 No

What is Overloading of procedures ?..

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

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

What is sql*loader?

0 Answers  


Can we use view in stored procedure?

0 Answers  


How to avoid duplicate records in a query?

0 Answers  


Where is sql database stored?

0 Answers  


What are the differences between Database Trigger and Integrity constraints ?

4 Answers  






Is sql considered coding?

0 Answers  


What is implicit cursor in pl sql?

0 Answers  


Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL

1 Answers   Societe Generale,


what is global table

7 Answers   iFlex,


What is a procedure in pl sql?

0 Answers  


What are the types of dbms?

0 Answers  


Can we use distinct and group by together?

0 Answers  


Categories