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
Transaction Visibility As the figure shows, the changes made by an autonomous transaction become visible to another transaction whenever the autonomous transaction commits. Th

Updating Variables For assignment, SQL uses the key word SET, as in SET X = X + 1 (read as "set X equal to X+1") rather than X: = X + 1 as found in many computer languages.

Question: (a) The objective of query optimization is to choose the most efficient strategy for implementing a given relational query, thereby improving the system performance. On

Use Native Dynamic SQL A few programs (a normal-purpose report writer for illustration) should build and process a variety of SQL statements at run time. Therefore, their full

BEGIN Parameter Description in pl sql: BEGIN: This keyword signals the beginning of the executable section of a PL/SQL block, that contains executable statements. The execut

Write a cursor to open an employee database and fetch the employee record whose age is greater than 45

Great Plains (Microsoft Dynamics) Purchases Report Project Description: I want to build a purchases report that matches the General Ledger. presently, when I join the PM20

Grouping and Ungrouping in SQL Example specifying EXAM_MARK in place of COURSE in the main FROM clause. Example: Obtaining C_ER2 from EXAM_MARK SELECT CourseId, CAST

Cursor Variables As Parameters You can declare the cursor variables as the formal parameters of the functions and procedures. In the illustration below, you define the REF CUR

Bulk Binds advantages In the Embedded Oracle RDBMS, the PL/SQL engines accept any valid PL/SQL subprogram or block. As the figure shows, the PL/SQL engine executes all procedur