1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Can you have multiple SPs with the same name on a database?

Question Posted / guest

Answers were Sorted based on User's Feedback



Can you have multiple SPs with the same name on a database? ..

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

Can you have multiple SPs with the same name on a database? ..

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

Post New Answer

More SQL PLSQL Interview Questions

What is mdf ldf and ndf?

0 Answers  

What is the most restrictive isolation level? : Transact sql

0 Answers  

How many sql statements are used? Define them.

0 Answers  

Why is the cursor important?

0 Answers  

What is normalization and types of normalization?

22 Answers   Etisbew, F-TEC, Microsoft, TechProcess,




What are the dml statements?

0 Answers  

What does the acronym acid stand for in database management?

0 Answers  

Enlist some predefined exceptions?

0 Answers  

Why we use pl sql?

0 Answers  

What are nested triggers ?

6 Answers   Amazon, Appeal Soft, IBM, Infosys, TCS,

What are the types of functions in sql?

0 Answers  

Explain two virtual tables available at the time of database trigger execution.

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories