Using forall and bulk collect - bulk bind performance, PL-SQL Programming

Using FORALL and BULK COLLECT Together

You can unite the BULK COLLECT clause with the FORALL statement, in that case, the SQL engine bulk-binds column values incrementally. In the illustration below, if the collection depts has 3 elements, each of which cause 5 rows to be deleted, then the collection enums has 15 elements when the statement completes:

FORALL j IN depts.FIRST..depts.LAST

DELETE FROM emp WHERE empno = depts(j)

RETURNING empno BULK COLLECT INTO enums;

Posted Date: 10/4/2012 3:31:42 AM | Location : United States







Related Discussions:- Using forall and bulk collect - bulk bind performance, Assignment Help, Ask Question on Using forall and bulk collect - bulk bind performance, Get Answer, Expert's Help, Using forall and bulk collect - bulk bind performance Discussions

Write discussion on Using forall and bulk collect - bulk bind performance
Your posts are moderated
Related Questions
Map and Order Methods: The values of the scalar datatype like CHAR or REAL have a predefined order that allows them to be compared. While, the instances of an object type has

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

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

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

Question: a) Given the following relation: Location(loc_id, bldg_code, room, capacity) The underlined field is a primary key. (i) Write a PL/SQL program using the impl

Literature review

Parameter and Keyword Description: collection_name: This keyword identifies the index-by table, nested table, or varray formerly declared within the present scope. cu

IF Statement The IF statement executes a series of statement conditionally. Whether the series is executed or not depends on the value of the Boolean expression. Syntax:

a. Write an anonymous block that contains a PL/SQL function. Given an order number orderNo, the function will calculate the total number of the parts in the order. Then the anonym

Running the PL/SQL Wrapper To run the PL/SQL Wrapper, go through the wrap command at your operating system prompt by using the syntax as shown: wrap iname=input_file [oname=