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
Overloading The PL/SQL overloads the subprogram names. That is, you can use similar name for few different subprograms as long as their formal parameters differ in the number

%ISOPEN The %ISOPEN yields TRUE if its cursor or cursor variable is open; or else, the %ISOPEN yields FALSE. In the illustration, you use the %ISOPEN to select an action:

Parameter and Keyword Description: select_item: This select_item is a value returned by the SELECT statement, and then assigned to the equivalent variable or field in the

Named Notation The second procedure call uses the named notation. An arrow (=>) serve as the relationship operator that associates the formal parameter to the left of the arro

What Are Cursor Variables  ? The Cursor variables are like C or Pascal pointers that hold the memory location (address) of some item rather of the item itself. Therefore, decl

"Not Enforced" Table Constraints A constraint that is not enforced is not really a constraint within the meaning of the act, but SQL does have such a concept and it needs to b

Using DELETE This process has three forms. The DELETE removes all elements from the collection. DELETE(n) removes the nth element from the nested table. When n is null, then D

ROWID and UROWID Internally, every database table has a ROWID pseudo column that stores binary values known as rowids. Each rowid shows the storage address of a row. A physical

Some Varray Examples In SQL Plus, assume that you define an object type Project, as described below: SQL> CREATE TYPE Project AS OBJECT ( 2 project_no NUMBER(2), 3 title VARCHA

Example of Table Literal - SQL Example: A Table Literal (correct version) VALUES ('S1', 'C1', 'Anne'), ('S1', 'C2', 'Anne'), ('S2', 'C1', 'Boris'), ('S3', 'C3'