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
Does pl/sql support create command?
What is sql in oracle?
What is sql resultset?
Can we use ddl statements in stored procedure?
What is cartesian join in sql?
Is it important to partition hard disk?
What is crud diagram?
What is a schema? How is it useful in sql servers?
how to fetch alternate records from a table? : Sql dba
how to analyze tables with 'mysqlcheck'? : Sql dba
Is sql injection illegal?
What version is sql?
What is the use of function "module procedure" in pl/sql?
What is the difference between local and global temporary table?
Explain what is a database?