Can you have multiple SPs with the same name on a database?
- 6 Answers
- 10293 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
explain primary keys and auto increment fields in mysql : sql dba
Write the alter statement to enable all the triggers on the t.students table.
What is audit logout in sql profiler?
Can you have more than one key in a database?
What is difference between mysql and postgresql?
Is left join and outer join same?
How can you get sql*loader to commit only at the end of the load file? : aql loader
What is difference between inner join and self join?
Enlist the data types that can be used in pl/sql?
What is set serveroutput on in pl sql?
What are tables in sql?
How does postgresql compare to mysql?
What is pragma in sql?
What is the most common sql injection tool?
What is java sql connection?
