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


Please Help Members By Posting Answers For Below Questions

how mysql optimizes distinct? : Sql dba

753


what are date and time data types? : Sql dba

721


What is the difference among union, minus and intersect?

762


what is the difference between primary key and unique key? : Sql dba

728


what is a database lock ? : Sql dba

814


What are primary key and foreign key and how they work?

765


What is relationship? How many types of relationship are there?

807


How many aggregate functions are available there in sql?

733


What is the difference between union and union all command?

773


What are sql built in functions?

700


what is a join? : Sql dba

791


What is sharding in sql?

750


How do I run a sql query?

765


How do I enable sql encryption?

735


Can we call a function containing dml statements in a select query?

743