Can you have multiple SPs with the same name on a database?
Answer Posted / ashok
IT WILL ONLY POSSIBLE FOR IN THE PACKAGE.
EX--
CREATE OR REPLACE PACKAGE PK_TEST AS
PROCEDURE PR_SHOW();
PROCEDURE PR_SHOW(V_NAME VAR CHAR);
END PK_TEST;
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is a field in a database?
What is the difference between microsoft access and sql server?
What are sql built in functions?
What is sql and its types?
What is type and rowtype in pl sql?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What is sql prepared statement?
What are basic techniques of indexing?
what is a database? : Sql dba
How many sql statements are used?
what are the different type of sql's statements ? : Sql dba
what is oltp (online transaction processing)? : Sql dba
What are user defined functions?
How does a trigger work?
Explain locks? : Transact sql