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
Collections:   The collection is an ordered group of elements, all of similar type (for illustration, the grades for a class of students). Each element has an exclusive subsc

Keyword and Parameter Description: table_reference: This specifies a table or view that should be accessible when you execute the DELETE statement, and for that you must

Write a cursor to open an employee database and fetch the employee record whose age is greater than 45

Example of NOT EXISTS in SQL Example: Use of NOT EXISTS CREATE ASSERTION Must_be_enrolled_to_take_exam_alternative1 CHECK ( NOT EXISTS (SELECT StudentId, CourseId

This is a Customer Management project. Customer data is presented in a text file. The program will load this text data into its DB columns. The data mapping is user definable. User

Effects of NULL The numeric variable X, perhaps of type INTEGER, might be assigned NULL. In that case the result of evaluating X + 1 is NULL, and so SET Y = X + 1 assigns NULL

LEVEL You use the LEVEL with the SELECT CONNECT BY statement to categorize rows from a database table into a tree structure. The LEVEL returns the level number of a node in a

SQL Functions The PL/SQL uses all the SQL functions involving the following aggregate functions that summarize the whole columns of the Oracle data: GROUPING, AVG, COUNT, STDDE

Write a query to find academics that are authors and that have only ever coauthored papers with authors from institutes in the same state as their own. List their academic number,

Task 2 [12 marks] Write the package body for the following package specification (the detailed description of each function and procedure is provided in the appendix below). Place