Keyword and parameter description - forall statement, PL-SQL Programming

Keyword &Parameter Description:

index_name:

This is an undeclared identifier which can be referenced only within the FORALL statement and only as the collection subscript.

The implicit declaration of the index_name overrides any other declaration outside the loop. Therefore, another variable with similar name cannot be referenced inside the statement. Inside a FORALL statement, the index_name cannot appear in the expressions and cannot be assigned a value.

lower_bound .. upper_bound:

These are the expressions which must yield integer values and should specify a valid range of the consecutive index numbers. The expressions are computed only when the FORALL statement is initially entered.

The index is assigned a value of the lower_bound. If that value is not bigger than the value of the upper_bound, the SQL statement is executed, and then the index is incremented. If the value of the index is still not bigger than the value of upper_ bound, then the SQL statement is executed again. This procedure repeats until the value of the index is bigger than the value of the upper_bound. At that point, the FORALL statement is completed.

sql_statement:

This must be an INSERT, DELETE, & UPDATE statement that references the collection of all elements.

Posted Date: 10/8/2012 6:46:35 AM | Location : United States







Related Discussions:- Keyword and parameter description - forall statement, Assignment Help, Ask Question on Keyword and parameter description - forall statement, Get Answer, Expert's Help, Keyword and parameter description - forall statement Discussions

Write discussion on Keyword and parameter description - forall statement
Your posts are moderated
Related Questions
Updating a Variable Assignment of an attribute value in a variable of a structured type Synatx: SET SN.C = 'S2'; As in Example the entire statement is equivalent to a

Define basic operators of relational algebra with an example each

Declaring a Cursor The Forward references are not allowed in the PL/SQL. Therefore, you must declare a cursor before referencing it in other statements. Whenever you declare a

Write a pl/sql block that declares and uses cursors with parameters. In a loop, use a cursor to retrieve the department number and the department name from the departments table

Raise_application_error -  procedure of package DBMS_STANDARD , allows to issue an user_defined error messages by stored sub-program or database trigger.

Example of Cast Operator So long as CAST is used as shown, we could obtain the total marks for each exam in similar fashion, using SUM (Mark) AS TotalMarks. However, this giv

Assignment Statement: The assignment statement sets the present value of the variable, parameter, field, or element. The statement consists of an assignment target followed by

Data Types and Representations This explains the concept possible representation, abbreviated possrep, and explains how these can be used in conjunction with constraints to de

Write a program to implement the inverted file shown in the slides (Simple Index file, LabelID file and Data file).  Use the Avail_List to point at the deleted Label IDs so that th

MECHANISTI S THEORY-HAECKEL (1866) - Haeckel stating that after each catalysm, some new organism suddenly forms as a chance event in one stride from inanimate matter and sub