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

Does pl/sql support create command?

572


What is sql in oracle?

623


What is sql resultset?

527


Can we use ddl statements in stored procedure?

696


What is cartesian join in sql?

557






Is it important to partition hard disk?

532


What is crud diagram?

509


What is a schema? How is it useful in sql servers?

591


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

591


how to analyze tables with 'mysqlcheck'? : Sql dba

542


Is sql injection illegal?

595


What version is sql?

553


What is the use of function "module procedure" in pl/sql?

665


What is the difference between local and global temporary table?

548


Explain what is a database?

645