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
How do I display usernames for students from a student table, assigning each student a username initials001 (initials is the actual student initials), and if the students initials

Ensuring Backward Compatibility   The PL/SQL Version 2 permits some abnormal behavior which Version 8 disallows. Particularly, Version 2 permits you to (i) Make the forw

Keys in SQL SQL support for keys in the following respects: SQL does not require at least one key for every base table. If no key is explicitly declared, then KEY {ALL B

Joining in SQL Joining IS_CALLED and IS_ENROLLED_ON in SQL SELECT * FROM IS_CALLED NATURAL JOIN IS_ENROLLED_ON This is an example of an SQL table expression. I have been

At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a trigger that automatically updates the stock level of all pr

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

Role of Abstraction in pl/sql: The abstraction is a high-level description or model of a real-world entity. The Abstractions keep our daily lives convenient. They help us ca

Using DEFAULT You can use the keyword DEFAULT rather than that of the assignment operator to initialize the variables. For e.g. the declaration blood_type CHAR := ’O’; it can b

Consider the schema for FreeChecking Bank, that we designed given below. Translate the given ER schema into SQL CREATE TABLE statements (indicating primary key, unique and foreign

Row Counterparts of Table Operators SQL does not have counterparts tuple rename, tuple projection, tuple extension, tuple join and tuple compose. To obtain the same effects as