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
Project Description: I am looking to change FullCalendar to add/delete sql server data when events are removed or dropped from Calendar. Events should only be included by dra

Understanding Nested Tables Within the database, the nested tables can be considered as one-column database tables. The Oracle stores the rows of a nested table in no specific o

a. Create a table odetails_new. It has all the attributes of odetails and an additional column called cost, whose values are the product of the quantity and price of the part bein

Need for Dynamic SQL: You need dynamic SQL in the situations as follows: 1) You would like to execute a SQL data definition statement (like CREATE), a data control statemen

I need SQL to infopath data connection Project Description: Want data retrieval connection from SQL to SharePoint infopath Skills required are Sharepoint, SQL

Number Types The Number types permit you to store the numeric data (real numbers, integers, and floating-point numbers), show quantities, and do computations. BINARY_INTEG

Manipulating Individual Elements Faraway you have manipulated an entire collection. Within the SQL, to manipulate the individual elements of the collection, and then use the ope

Controlling Autonomous Transactions The first SQL statement in an autonomous routine starts a transaction. Whenever one transaction ends, the next SQL statement starts the oth

Parameter and Keyword Description: cursor_variable_name: This identifies a cursor variable or the parameter formerly declared within the present scope. host_cursor_va

Controlling Cursor Variables You use 3 statements to control the cursor variable: OPEN-FOR, FETCH, & CLOSE. At First, you OPEN a cursor variable FOR a multi-row query. Then, y