Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / harsha

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

Is This Answer Correct ?    4 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is ttitle and btitle?

768

What is clustered index in sql?

785

Can one improve the performance of sql*loader? : aql loader

773

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

940

How to raise user-defined exception with custom sqlerrm ?

863




Explian rowid, rownum?

751

Is it possible to link two groups inside a cross products after the cross products group has been created?

769

what is the difference between where clause and having clause? : Sql dba

723

What is rownum in sql?

762

Is record in oracle pl sql?

696

what is normalization? : Sql dba

737

Describe sql comments?

728

Explain the purpose of %type and %rowtype data types with the example?

744

What is sql keyword?

755

Can we insert in view in sql?

776