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

Describe different types of general function used in sql?

620


what are the differences among rownum, rank and dense_rank? : Sql dba

611


What is user defined functions?

670


What is a relationship and what are they?

678


What are the subsets of sql?

637






In what condition is it good to disable a trigger?

652


Why we use pl sql?

613


what is the syntax used for partition in tsql? : Transact sql

636


Explain raise_application_error.

726


What do you understand by pl/sql cursors?

648


Can we join same table in sql?

649


Differentiate between sga and pga.

786


What are three advantages to using sql?

641


What is dml and ddl?

609


Does pdo prevent sql injection?

607