Interested to Buy Any Domain ? << Click Here >> for more details...
Can you have multiple SPs with the same name on a database?
- 6 Answers
- 12278 Views
- CGI, I also Faced
- E-Mail Answers
Answer Posted / harsha
Yes We can have multiple SP's with same name.This is called
overloading a Procedure with different parameters.
e.g. CREATE PROCEDURE COMPUTE_AREA (LENGTH IN NUMBER,
WIDTH IN NUMBER);
CREATE PROCEDURE COMPUTE_AREA (LENGTH IN NUMBER,
WIDTH IN NUMBER
UNITS IN NUMBER);
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
What are sql injection vulnerabilities?
Is crud a cuss word?
can sql servers linked to other servers like oracle? : Sql dba
what is normalization? : Sql dba
describe transaction-safe table types in mysql : sql dba
How exception handling is done in advance pl/sql?
What problem one might face while writing log information to a data-base table in pl/sql?
What is difference between stored function and application function?
What is the purpose of my sql?
How do I write a sql query in pgadmin 4?
Explain ddl statements in pl/sql?
How do I trace sql profiler?
How to call a javascript function from pl sql?
What is the difference between local and global temporary table?
how to enter characters as hex numbers? : Sql dba
