Can you have multiple SPs with the same name on a database?

Answers were Sorted based on User's Feedback



Can you have multiple SPs with the same name on a database? ..

Answer / neha sinha

It is not possible to create standalone SP with same name.
But it is possible if we will create multiple SP with same
name and different parameter in a package (overloading).

Is This Answer Correct ?    8 Yes 0 No

Can you have multiple SPs with the same name on a database? ..

Answer / nrapendra

function overloadding is allowed in pl sql .we can creete
multiple sp of same name but paramerter should be different.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

wa procedure to return the month and the no'f developers joined in each month.

4 Answers   Fidelity,


how to insert the records in particular position

1 Answers  


Which data type doesn't allow null data type?

6 Answers   TCS,


ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,


What is trigger types of trigger?

0 Answers  






what is the difference between implicit conversions and explicit conversions?

2 Answers  


Can you have multiple SPs with the same name on a database?

2 Answers   CGI, Quest,


what is a stored procedure? : Sql dba

0 Answers  


how can i read files from a pl/sq l program

3 Answers  


how will be date change into string

4 Answers  


How you improve the performance of sql*loader? : aql loader

0 Answers  


What is the difference between syntax error and runtime error?

0 Answers  


Categories