Can you have multiple SPs with the same name on a database?
- 2 Answers
- 6430 Views
- CGI, Quest, I also Faced
- E-Mail Answers
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 to move files from one directory to another in pl sql?
Can we commit inside a trigger?
What are different types of tables in sql?
What is data types in sql?
Difference between SUBSTR and INSTR?
Can you join a table to itself?
What are the types of sql commands?
Can a view be mutating? If yes, then how?
What is cursor in pl sql?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
How is a process of pl/sql compiled?
What does (+) mean in sql joins?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
