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

Answer Posted / suman

Hi ,

As per standard Procedure & Function we cannot create same name of Procedure but if you are using in Package you can have same name with different parameter.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are predefined functions in sql?

531


Why is sql better than hql?

504


what is the difference between delete and truncate statement in sql? : Sql dba

546


Explain the uses of a database trigger?

564


What is the main reason behind using an index?

551






What are the types of queries in sql?

516


What is the difference between local and global temporary table?

548


What is cursor explain with example?

551


What is the difference between an inner join and an outer join?

513


What are the main features of cursor?

627


Is sql better than excel?

517


What are properties of the transaction?

554


What is trigger and how to use it in sql?

536


What is input buffer in sql*plus?

638


What is bulk compiling in pl/sql.?

607