Can you have multiple SPs with the same name on a database?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / nrapendra
function overloadding is allowed in pl sql .we can creete
multiple sp of same name but paramerter should be different.
Is This Answer Correct ? | 3 Yes | 0 No |
Can we rollback truncate?
How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id
Why plvtab is considered as the easiest way to access the pl/sql table?
There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.
Can we insert in view in sql?
How do I count duplicates in sql?
What is compound trigger?
Is postgresql a nosql database?
What does over partition by mean in sql?
What is the purpose of design view?
Difference between DBMS and RDBMS...CODD's rules
What is cross join sql?