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
Develop Data Business Intelligence Project Project Description: We are linking our Microsoft SQL Database to GoodData Business Intelligence. We are seeking somebody who has e

Using INNER JOIN INNER JOIN is used to retrieve the data from all tables listed based on a condition of equality listed after keyword ON. If the condition is not meet, rows ar

EXIT The EXIT statement forces a loop to done unconditionally. Whenever an EXIT statement is encountered, the loop is done immediately and controls the passes to the next statem

LONG and LONG RAW You use the LONG datatype to store the variable-length character strings. The LONG datatype is such as the VARCHAR2 datatype, except that the maximum length o

V ariables and Constants in PL/SQL The PL/SQL permits you to declare constants and variables, and then use them in SQL and procedural statements anywhere in the expression. Th

We are seeking a freelance consultant that is familiar with Appgen applications. We require exporting all our data into a format appropriate for importing into SAP Business One. Pl

Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

Example of ADD CONSTRAINT in SQL Example: Alternative formulation for MAX_ENROLMENTS ALTER TABLE IS_ENROLLED_ON ADD CONSTRAINT MAX_ENROLMENTS CHECK ((SELECT COUNT (*)

Disjunction (OR, ∨) Again we have nine rows instead of just four and again, when unknown is not involved, the rows are as for 2VL. Also, when anything is paired with true, t

Parameter and Keyword Description: label_name: This is an undeclared identifier which optionally labels a loop. When used, the label_name should be enclosed by double ang