Can you have multiple SPs with the same name on a database?
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 is bdb (berkeleydb)? : Sql dba
What is a join?
what is a field in a database ? : Sql dba
How to connect a sql*plus session to an oracle server?
Is sql dba a good career? : SQL DBA
what is acid property in database? : Sql dba
How does cross join work in sql?
What type of join is sql join?
How can a function retun more than one value in oracle with proper example?
What is rename command in sql?
What is data manipulation language?
How would you reference column values before and after you have inserted and deleted triggers?
how to enter characters as hex numbers? : Sql dba
How do I run a sql query?
What are the uses of merge?