Overloading method in pl/sql, PL-SQL Programming

Overloading:

Similar to packaged subprograms, methods of the same type can be overloaded. That is, you can use similar name for various methods if their formal parameters differ in order, number, or datatype family. When you call one of the methods, the PL/SQL finds it by comparing the list of the real parameters with each list of the formal parameters.

You cannot overload 2 methods if their formal parameters differ only in parameter mode. Also, you cannot overload 2 member functions that differ only in return type

 

Posted Date: 10/6/2012 8:08:06 AM | Location : United States







Related Discussions:- Overloading method in pl/sql, Assignment Help, Ask Question on Overloading method in pl/sql, Get Answer, Expert's Help, Overloading method in pl/sql Discussions

Write discussion on Overloading method in pl/sql
Your posts are moderated
Related Questions
Change Sql file into CSV for product registration on Magento Project Description: I have a set of files that are in Sql format and could like for a developer to help me with

Inserting Objects: You can use the INSERT statement to add objects to an object table. In the illustration below, you insert a Person object into the object table persons:

IN Operator The operator IN tests the set membership. This means "equal to any member of." The set may have nulls, but they are ignored. For illustration, the statement below do

Initializing Records The illustration below shows that you can initialize a record in its type definition. Whenever you declare a record of the type TimeRec, its 3 fields supp

FETCH Statement The FETCH statement retrieve rows of data one at a time from the result set of the multi-row query. The data is stored in fields or variables which correspond t

Remote Operations: As the illustration shows below, the PL/SQL subprograms can execute the dynamic SQL statements which refer to the objects on a remote database: PROCEDURE

1. Create a procedure called TAX_COST_SP to accomplish the tax calculation task. Keep in mind that the state and subtotal values are inputs into the procedure and the procedure is

Ending Transactions A good quality programming practice is to commit or roll back every transaction explicitly. Whether you rollback or issue the commit in your PL/SQL program

Error Handling The PL/SQL makes it easy to detect and process the predefined and user-defined error conditions known as exceptions. Whenever an error occurs, an exception is ra

PITS Depressions in secondary cell wall is called pit. A pit present on the free cell wall surface without its partner is called Blind pit. It consists of 2 parts -