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 |
How does pl sql work?
What operators deal with null?
Is sql similar to python?
Why is theta join required?
What are Lexical Parameters.How They are used in Reports 6i
What is a common use of group by in sql?
What are all the ddl commands?
what is 'mysqldump'? : Sql dba
How do you optimize a stored procedure in sql?
Does view store data in sql?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is gpt format?
Oracle (3253)
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)