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 |
wa procedure to return the month and the no'f developers joined in each month.
how to insert the records in particular position
Which data type doesn't allow null data type?
ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.
What is trigger types of trigger?
what is the difference between implicit conversions and explicit conversions?
Can you have multiple SPs with the same name on a database?
what is a stored procedure? : Sql dba
how can i read files from a pl/sq l program
how will be date change into string
How you improve the performance of sql*loader? : aql loader
What is the difference between syntax error and runtime error?