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

Can we rollback truncate?

0 Answers  


How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

8 Answers   CGCI,


Why plvtab is considered as the easiest way to access the pl/sql table?

0 Answers  


There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.

2 Answers   Maruti Suzuki,


Can we insert in view in sql?

0 Answers  






How do I count duplicates in sql?

0 Answers  


What is compound trigger?

0 Answers  


Is postgresql a nosql database?

0 Answers  


What does over partition by mean in sql?

0 Answers  


What is the purpose of design view?

0 Answers  


Difference between DBMS and RDBMS...CODD's rules

4 Answers   Polaris,


What is cross join sql?

0 Answers  


Categories