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
Data Types in SQL - Interval, Boolean INTERVAL for values denoting, not intervals (!) but durations in time, such as 5 years, 3 days, 2 minutes, and so on. BOOLEAN, con

DBMS_PIPE: The Package DBMS_PIPE allows various sessions to communicate over the named pipes. (A pipe is a region of memory used by one of the process to pass information to

PL SQL Code Review HEADER ELEMENTS File Name Clear, meaningful and descriptive about main objective of the file. Multiple words are joined using underscores which adh

Implicit Cursors The Oracle implicitly opens a cursor to process each SQL statement not related with an explicitly declared cursor. The PL/SQL lets you refer to the most recen

Information Hiding   With the information hiding, you see only the details that are significant at a given level of algorithm and data structure design. The Information hiding

Based on the EMPLOYEE table created in Assignment #1, write a PL/SQL anonymous block that accepts an employee ID from the user input and finds whether the employee ID is in the EMP

What are 3 good practices of modeling and/or implementing data warehouses?

Example of Shorthand for a row constraint Example: Shorthand for a row constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Mark_in_range CHECK (Mark BETWEEN 0 AND 100);

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

Question 1 . Compare SQL and PL/SQL Question 2 . Write a database trigger to implement the following check condition                          Given the following table