Sign Up Login


  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 are the disadvantages of file system?

0 Answers  

What is sql key?

0 Answers  

How do I run a sql trace?

0 Answers  

how to fetch alternate records from a table? : Sql dba

0 Answers  

How do you clear the screen in sql?

0 Answers  

What is compound trigger?

0 Answers  

Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.

1 Answers   CTS,

What program will open a mdb file?

0 Answers  

What is the syntax to add a record to a table?

0 Answers  

What is difference between procedure and trigger?

0 Answers  

Which software is used for pl sql programming?

0 Answers  

how to get a list of columns in an existing table? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories