What is Overloading of procedures ?

Answers were Sorted based on User's Feedback



What is Overloading of procedures ?..

Answer / tulsi

The Same procedure name is repeated with parameters of
different datatypes and parameters in different positions,
varying number of parameters is called overloading of
procedures.

e.g. DBMS_OUTPUT put_line

Is This Answer Correct ?    2 Yes 0 No

What is Overloading of procedures ?..

Answer / nithin

The procedures with same name and difference in
number,order or data type family. The pjrocedures should be
in PL/SQL block, a sub program or package. Stand alone
procedures cannot be overloaded.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

how to add a new column to an existing table in mysql? : Sql dba

0 Answers  


can i call procedure in package

3 Answers   TCS,


how to present a past time in hours, minutes and seconds? : Sql dba

0 Answers  


What is sql server and ase?

0 Answers  


When is a declare statement required?

0 Answers  






Explain spool.

0 Answers  


Is sql a dbms?

0 Answers  


What is a sql instance vs database?

0 Answers  


How does sql developer connect to oracle database?

0 Answers  


what is self join and how it works??

2 Answers   Infosys,


How do I count duplicates in sql?

0 Answers  


What are pl sql data types?

0 Answers  


Categories