overloading of stored procedure is possible in oracle?
Answer Posted / neeraj siddhey
Overloading: Multiple subprograms of the same name
• Enables you to use the same name for different
subprograms inside a PL/SQL block, a subprogram, or a
package
• Requires the formal parameters of the subprograms to
differ in number, order, or data type family
• Enables you to build more flexibility because a user or
application is not restricted by the specific data type or
number of formal parameters
Note: Only local or packaged subprograms can be overloaded.
You cannot overload stand-alone subprograms.
Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is the difference between truncate and drop statements?
Can we join two tables without common column?
What is sql profiling in oracle?
What is sql indexing?
what is the difference between myisam static and myisam dynamic? : Sql dba
What is the difference between in and between in sql?
What is the importance of sqlcode and sqlerrm?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
What is oracle pl sql developer?
What do you understand by case manipulation functions?
What is a file delimiter?
What is substitution variable?
Which software is used for pl sql programming?
What is dba in sql? : SQL DBA
how can we know the count/number of elements of an array? : Sql dba