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
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


Other monadic - SQL In 2VL there are just 4 (2 2 ) monadic operators, of which negation is really the only "useful" one. When a third truth value is introduced we have 27 (3 3

Comparison Operators Usually, you use the comparison operators in the WHERE clause of a data manipulation statement to form the predicates, that compare one expression to anot

Parameter and Keyword Description: cursor_name: This identifies an explicit cursor formerly declared within the present scope. cursor_variable_name: These identif

Sequential Control Dissimilar to the IF and LOOP statements, the GOTO and NULL statements are not important to the PL/SQL programming. The configuration of PL/SQL is such that th

%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:

If two relations R and S are joined, then the non matching tuples of both R and S are ignored in __________________.

The SQL ‘CREATE TABLE' scripts for all the tables you have implemented. Note that your tables must correspond exactly to the ERD you have provided in 1. above, or you will lose ma

Type versus Representation Confusion in SQL This describes how a value might have two or more distinct representations. For example, user-defined type POINT might have a decla