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

Answer Posted / neha sinha

It is not possible to create standalone SP with same name.
But it is possible if we will create multiple SP with same
name and different parameter in a package (overloading).

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can a varchar be a primary key?

701


What is basic structure of pl sql?

690


What is a record in a database?

773


Does a join table need a primary key?

708


Can we create table in function?

732






What is sql analyzer?

759


how to use 'mysql' to run sql statements? : Sql dba

741


What is #table in sql?

706


Can we use ddl statements in stored procedure?

887


What are the sql aggregate functions?

815


Does truncate require commit?

718


how to create a table index in mysql? : Sql dba

751


What is oracle pl sql developer?

706


First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1341


Is sql dba a good career? : SQL DBA

718