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

Answer Posted / ashok

IT WILL ONLY POSSIBLE FOR IN THE PACKAGE.
EX--
CREATE OR REPLACE PACKAGE PK_TEST AS
PROCEDURE PR_SHOW();
PROCEDURE PR_SHOW(V_NAME VAR CHAR);
END PK_TEST;

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to include an insert statement on the same table to which the trigger is assigned?

641


What are different types of triggers?

658


How do I view a view in sql?

599


how to present a past time in hours, minutes and seconds? : Sql dba

651


How do you update f as m and m as f from the below table testtable?

1285






How does join work in sql?

654


what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

651


what is difference between delete and truncate commands? : Sql dba

680


What is cursor explain with example?

652


What is a database trigger?

705


What is cursor and its types?

635


What is the difference between microsoft access and sql?

592


What does trigger mean in psychology?

624


Explain commit, rollback and savepoint.

695


what are the advantages of sql ? : Sql dba

640