Can you have multiple SPs with the same name on a database?
Answer Posted / neha sinha
It is not possible to create standalone SP with same name.
But it is possible if we will create multiple SP with same
name and different parameter in a package (overloading).
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
When sql appeared?
How many commands are there in sql?
Can we create a trigger on view?
what are the differences among rownum, rank and dense_rank? : Sql dba
What are the rules to be applied to nulls whilst doing comparisons?
What is difference between procedure and trigger?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
What is cte sql?
What are the advantages of sql? Explain
What is sqlcommand?
Inline the values in PL/SQL, what does it mean.?
what is a materialized view? : Sql dba
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
Define commit, rollback and savepoint?
What is difference between stored function and application function?