Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is Overloading of procedures ?

Question Posted / swapna

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

If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING

10 Answers   HCL, TCS,

What are the different types of a subquery?

0 Answers  

What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   Cap Gemini, Infosys, TCS,

How do you optimize a stored procedure in sql?

0 Answers  

What do you mean by field in sql?

0 Answers  

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

what is uncommittable transactions? : Transact sql

0 Answers  

How long does it take to learn pl sql?

0 Answers  

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

0 Answers  

What is dml statement?

0 Answers  

how to connect oracle in unix prompt?

4 Answers   Polaris,

Talk about views

10 Answers   Polaris,

For more SQL PLSQL Interview Questions Click Here
Categories