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

how to use myisamchk to check or repair myisam tables? : Sql dba

711


Can you select everything, but 1 or 2 fields, without writer's cramp?

689


How do we accept inputs from user during runtime?

730


Is it possible for a table to have more than one foreign key?

774


what are date and time intervals? : Sql dba

759






Is join an inner join?

718


Which one is better subquery or joins?

775


What is coalesce sql?

695


What is sql indexing?

754


What is the order of sql select?

763


Is nosql faster than sql?

745


What does data normalization mean?

717


Define select, insert, create, delete, update, drop keywords

776


how to use regular expression in pattern match conditions? : Sql dba

730


What are the different types of functions in sql?

759