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

what is a unique key ? : Sql dba

1 Answers  


what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1 Answers  


what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1 Answers  


Is left join inner or outer by default?

1 Answers  


can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 Answers  


What is the diffrence between IN and EXISTS.which one is faster.

3 Answers   Infogain,


how many tables will create when we create table, what are they? : Sql dba

0 Answers  


What is a schema in sql?

1 Answers  


How do I sort a table in sql?

1 Answers  


What is data modelling in sql?

1 Answers  


What's the difference between inner join and left join?

1 Answers  


What is a boolean in sql?

1 Answers  


Categories