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 normalisation in sql?
give the syntax of grant and revoke commands? : Sql dba
What is keys and its types?
Which is faster truncate or drop?
How do I sort a table in sql?
How do you determine the current isolation level? : Transact sql
Is it possible to pass parameters to triggers?
How do you change a value in sql?
What is query execution plan in sql?
What's the difference between a primary key and a clustered index?
What is the difference between row level and statement level trigger?
what is user defined functions? : Sql dba
What are the uses of sysdate and user keywords?
How do I view tables in mysql?
What are analytical functions in sql?