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
how to use myisamchk to check or repair myisam tables? : Sql dba
Can you select everything, but 1 or 2 fields, without writer's cramp?
How do we accept inputs from user during runtime?
Is it possible for a table to have more than one foreign key?
what are date and time intervals? : Sql dba
Is join an inner join?
Which one is better subquery or joins?
What is coalesce sql?
What is sql indexing?
What is the order of sql select?
Is nosql faster than sql?
What does data normalization mean?
Define select, insert, create, delete, update, drop keywords
how to use regular expression in pattern match conditions? : Sql dba
What are the different types of functions in sql?