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 |
Please let me know if UNION ALL and Natural Join does the same operation and are same...
What is union, minus and interact commands?
What are triggers, and when would you use them?
Is sql a microsoft product?
define sql delete statement ? : Sql dba
How to call the function and Procedure in trigger?
what are ddl statements in mysql? : Sql dba
How to look at the current sql*plus system settings?
What is the importance of sqlcode and sqlerrm?
which will fire first ? Trigger or Constraint
24 Answers i2, IBM,
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
Why do we need cursors in pl 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)