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
1. Create a procedure called TAX_COST_SP to accomplish the tax calculation task. Keep in mind that the state and subtotal values are inputs into the procedure and the procedure is

Second Step at defining type SID in SQL CREATE TYPE SID AS VARCHAR(5) ; Explanation: TYPE SID announces that a type named SID is being defined to the system.

SQL Database: So, an SQL database is one whose symbols are organized into a collection of tables. Now, shows an SQL table as the current value of an SQL variable, ENROLMENT, b

Cursors The Oracle uses work areas to execute the SQL statements and to store process information. A PL/SQL construct known as the cursor. Let's you assume name a work area and

Introduction Oracle 9i - it was made public in the year 2001 with over 400 features, and graphics, it has merged the traditional business with modern internet application

Mutual Recursion The Subprograms are mutually recursive if they directly or indirectly call each other. In the illustration below, the Boolean functions odd & even, that dete

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

Oracle 10G new features:- Automatic Database Diagnostic Monitor System Advancements - these methods will provides several methods for extracting reports through the Automatic

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

Parameter SELF in pl/sql The MEMBER methods recognize a built-in parameter named SELF that is an instance of the object type. Whether declared explicitly or implicitly, it is