Can you have multiple SPs with the same name on a database?
Answers were Sorted based on User's Feedback
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 |
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 |
Does a join table need a primary key?
What is scope of pl sql developer in future?
What is over () in sql?
What is pragma exception and how, when, where us
What is difference between sql and excel?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
Which command is used to delete a package?
Which one is better sql or oracle?
What are the benefits of pl sql?
What is mdb stand for?
Explain lock escalation? : Transact sql
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)