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

Can i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)

6 Answers  


Why use stored procedures?

0 Answers  


Can we use loop in sql?

0 Answers  


Which one is better subquery or joins?

0 Answers  


What is the use of a view in sql?

0 Answers  






What is number function in sql?

0 Answers  


What is dml statement?

0 Answers  


What has stored procedures in sql?

0 Answers  


What is materialized view in sql?

0 Answers  


How to return an array from java to pl/sql?

0 Answers  


What are system versioned tables?

0 Answers  


What are sql indexes?

0 Answers  


Categories