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
Semidifference via NOT IN and a subquery SELECT StudentId FROM IS_CALLED WHERE Name = 'Devinder' AND StudentId NOT IN (SELECT StudentId FROM IS_ENROLLED_ON WHER

Parameter and Keyword Description:   table_reference: This identifies a table or view which should be available when you execute the INSERT statement, and for that you sho

Effects of NULL in Aggregate Operator - SQL Let aggop(x) be an invocation of some aggregate operator aggop in SQL, where x is an expression (usually an open expression) to be

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

Semidifference via EXCEPT and JOIN - SQL SELECT * FROM (SELECT StudentId FROM IS_CALLED WHERE Name = 'Devinder' EXCEPT DISTINCT CORRESPONDING SELECT StudentId

Aggregate Operators SQL Supports all of the aggregate operators mentioned in the theory book and many more besides. The syntax, however, involves an unusual trick that SQL cal

%TYPE Attribute The %TYPE attribute gives the datatype of a record, field, nested table, database column, or the variable. You can use the %TYPE attribute as the datatype speci

Using a Join on 2 tables, select all columns and all rows from the tables without the use of a Cartesian product. Query: SELECT * FROM EMPLOYEE1 JOIN CONTRACT ON EMPLOYEE

LIKE Operator You use the LIKE operator to compare the character value to a pattern. The Case is significant. LIKE returns the Boolean value TRUE when the character patterns mat