IT WILL ONLY POSSIBLE FOR IN THE PACKAGE. EX-- CREATE OR REPLACE PACKAGE

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

Question Posted / ashok

6 Answers
12028 Views
CGI, I also Faced
E-Mail Answers

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

Can you selectively load only those records that you need? : aql loader

1044

What is the use of desc in sql?

973

What is the difference between function, procedure and package in pl/sql?

1245

what is the command used to fetch first 5 characters of the string? : Sql dba

1634

What is the purpose of primary key?

1017

What are packages in pl sql and also explain its advantages?

1027

What do you understand by pl/sql records?

1014

What is sql performance tuning?

913

Which table is left in left join?

1010

Explain the uses of database trigger.

1112

What is trigger explain it?

1011

What are different types of statements supported by sql?

1161

How can you fetch common records from two tables?

1056

Explain lock escalation? : Transact sql

1192

What is scalar data type in pl sql?

1066