Forall statement - syntax, PL-SQL Programming

FORALL Statement

The FORALL statements instruct the PL/SQL engine to bulk-bind the input collections before sending them to the SQL engine. Though the FORALL statement consists an iteration scheme, however it is not a FOR loop.

Syntax:

1781_forall statement.png

 

 

 

Posted Date: 10/8/2012 6:45:40 AM | Location : United States







Related Discussions:- Forall statement - syntax, Assignment Help, Ask Question on Forall statement - syntax, Get Answer, Expert's Help, Forall statement - syntax Discussions

Write discussion on Forall statement - syntax
Your posts are moderated
Related Questions
Declaring Cursor Variables Once a REF CURSOR type is define by you, and then you can declare the cursor variables of that type in any PL/SQL block or subprogram. In the exampl

BEGIN Parameter Description in pl sql: BEGIN: This keyword signals the beginning of the executable section of a PL/SQL block, that contains executable statements. The execut

Name Resolution In potentially uncertain SQL statements, the names of the database columns take precedence over the names of the local variables and formal parameters. For e.g.

i NEED THE QURIES TO SOME OF THE PROBLEMS USING plsql

Oracle 11 G new features associated with this release:- Enhanced ILM  - Information Lifecycle Management (ILM) has been around for the almost 10 years, but Oracle has made

Using PRIOR and NEXT The PRIOR(n) returns the index number that precede index n in a collection. The NEXT(n) returns the index number which succeed the index n. If n has no pr

Manipulating Objects: You can use an object type in the CREATE TABLE statement to indicate the datatype of a column. When the table is created once, you can use the SQL statem

Example of Foreign Key Constraint Example: Alternative formulation for 6.3 as a foreign key constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_take_exam

Closing a Cursor Variable The CLOSE statement disables the cursor variable. After that, the related result set is undefined. The syntax for the same is as shown below: CLOS

to write a heap sort program usin pl-sql