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 |
What is the mutating table and constraining table?
What are system versioned tables?
What found sql?
How do you update sql?
What is difference between hql and sql?
what are the different tables present in mysql? : Sql dba
how to convert dates to character strings? : Sql dba
what is single byte over head in oracle..?
what is the difference between primary key and unique key? : Sql dba
What does where 1 1 mean in sql?
what are properties of a transaction? : Sql dba
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
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)