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
Packaging Cursors   You can split a cursor specification from its body for placement in a package. In that way, you can change the cursor body without changing the cursor spec

What Is a Record  ? A record is a group of related data items that stored in the fields, each with its own name and datatype. Assume that you have different data about an em

Example of UNWRAP Operator - SQL Example here shows how unwrapping can be done in longhand in SQL. Example: Unwrapping in SQL Letting CONTACT_INFO_WRAPPED denote the res

Using RENAME in combination with JOIN - SQL Example gives pairs of ids of students having the same name, by joining two renamings of IS_CALLED. Example gives an equivalent ex

Closest Approximation to Relational Union - SQL Actually, just as SQL has several varieties of JOIN, it also has several varieties of UNION, none of which is equivalent to th

Table Literals - SQL One might expect SQL to support table literals in the manner illustrated in Example 2.2, but in fact that is not a legal SQL expression. Example: Not a

Predicate - SQL Consider the declarative sentence-a proposition-that is used to introduce this topic:  "Student S1, named Anne, is enrolled on course C1." Recall that th

Multiset types - SQL An SQL multiset is what in mathematics is also known as a bag-something like a set except that the same element can appear more than once. The body of an

I need SQL , WP SQL Expert Project Description: Expert required to modify WP SQL query. Skills required are MySQL, SQL, PHP, Wordpress

Scoping Within the similar scope, all the declared identifiers should be unique. So, even if their datatypes differ, the variables and parameters cannot share the similar name.