Answer / jithendranath.g

both above answers are correct,but situvationd diff
1) we can't create same db obj with same name,
2) we want that go for packages ,with overloading concept

Answer / baba

When we create a stored procedure,if db object already
exists we will get a message that
ERROR at line 1:
ORA-00955: name is already used by an existing object

Answer / 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;

Answer / suman

Hi ,

As per standard Procedure & Function we cannot create same name of Procedure but if you are using in Package you can have same name with different parameter.

Answer / harsha

Yes We can have multiple SP's with same name.This is called
overloading a Procedure with different parameters.
e.g. CREATE PROCEDURE COMPUTE_AREA (LENGTH IN NUMBER,
WIDTH IN NUMBER);
CREATE PROCEDURE COMPUTE_AREA (LENGTH IN NUMBER,
WIDTH IN NUMBER
UNITS IN NUMBER);

Answer / thra

yes procedure can have same name overloading differ in data
type ....etc;

Is join and inner join the same?

0 Answers  

How do I use google cloud in sql?

0 Answers  

What is the file extension for sql database?

0 Answers  

While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers   HSBC,

Does access use sql?

0 Answers  

What are predefined functions in sql?

0 Answers  

What are its different types of dbms?

0 Answers  

Which join is like an inner join?

0 Answers  

What is a table in a database?

0 Answers  

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

Why indexing is needed?

0 Answers  

What is procedure and function?

0 Answers