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

What is nosql example?

0 Answers  

What is the execution plan in sql?

0 Answers  

what is the difference between binary_integer and pls_integer

2 Answers   TCS,

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers   iNautix, Oracle,

what are different types of keys in sql?

0 Answers  

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

0 Answers  

what is the bond code in materialized view?

0 Answers  

what is sql? : Sql dba

0 Answers  

A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

2 Answers   TCS,

What are the cursor attributes used in PL/SQL ?

4 Answers  

Types of joins ?

3 Answers   Digital GlobalSoft, HeadStrong,

Can a table have two primary keys?

44 Answers   HCL, MetaCube,

For more SQL PLSQL Interview Questions Click Here
Categories