Interested to Buy Any Domain ? << Click Here >> for more details...
overloading of stored procedure is possible in oracle?
- 3 Answers
- 15947 Views
- Nelco, I also Faced
- E-Mail Answers
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
how to check myisam tables for errors? : Sql dba
What is the life of an sql statement?
What is sql injection vulnerability?
How can we store rows in PL/SQL using array?
Explain what is a subquery ?
What are the various restrictions imposed on view in terms of dml?
Is sql free?
What does inner join mean?
how to delete an existing column in a table? : Sql dba
How does sql*loader handles newline characters in a record? : aql loader
What is a variable in sql?
What does seeding a database mean?
What is a native sql query?
Can we insert data into view?
What does stand for in sql?
