Positional and named notation, PL-SQL Programming

Positional and Named Notation

You can write the actual parameters when calling a subprogram, using either positional or named notation. That is, you can point to the relationship between an actual and formal parameter by the position or name. Therefore, the given declarations are:

DECLARE

acct INTEGER;

amt REAL;

PROCEDURE credit_acct (acct_no INTEGER, amount REAL) IS ...

You can call the procedure credit_acct in 4 logically equal ways:

BEGIN

credit_acct(acct, amt); -- positional notation

credit_acct(amount => amt, acct_no => acct); -- named notation

credit_acct(acct_no => acct, amount => amt); -- named notation

credit_acct(acct, amount => amt); -- mixed notation

Posted Date: 10/5/2012 5:28:57 AM | Location : United States







Related Discussions:- Positional and named notation, Assignment Help, Ask Question on Positional and named notation, Get Answer, Expert's Help, Positional and named notation Discussions

Write discussion on Positional and named notation
Your posts are moderated
Related Questions
Using %TYPE The %TYPE attribute gives the datatype of a variable or the database column. In the example below, the %TYPE gives the datatype of a variable: credit REAL(7,2); debi

Equivalences & Rewrite Rules: If notice that as well as allowing us to prove trivial theorems, and tautologies enable us to establish that certain sentences are saying the sam

Explicit Cursors The set of rows returned by the query can include zero, one, or multiple rows, depending on how many rows meet your search criteria. Whenever a query returns

1. a. Write a trigger that fires when a part's price is updated. The trigger will write a record into a table called PriceUpdates. The record should contain the information of

Organi c Evolution Evolution is a slow continuous, irreversible and natural process of change to give rise to advance and diverse forms of life i.e. formation of new specie

Oracle 10G new features:- Automatic Database Diagnostic Monitor System Advancements - these methods will provides several methods for extracting reports through the Automatic

Variable Declaration - SQL SQL's support for variables is very similar to Tutorial D's, except that the syntax for creating persistent  variables-base tables-is quite differen

SQL Cursor   The Oracle implicitly opens a cursor to process each SQL statement not related with an explicit cursor. The PL/SQL refers to the most current implicit cursor as t

Defining and Declaring Collections To create the collections, you must define a collection type, and then declare the collections of that type. You can define the VARRAY types a

Parameter SELF in pl/sql The MEMBER methods recognize a built-in parameter named SELF that is an instance of the object type. Whether declared explicitly or implicitly, it is