Bulk fetching - bulk bind performance improvement, PL-SQL Programming

Bulk Fetching

The illustration below shows that you can bulk-fetch from a cursor into one or more collections:

DECLARE

TYPE NameTab IS TABLE OF emp.ename%TYPE;

TYPE SalTab IS TABLE OF emp.sal%TYPE;

names NameTab;

sals SalTab;

CURSOR c1 IS SELECT ename, sal FROM emp WHERE sal > 1000;

BEGIN

OPEN c1;

FETCH c1 BULK COLLECT INTO names, sals;

...

END;

Posted Date: 10/4/2012 3:30:54 AM | Location : United States







Related Discussions:- Bulk fetching - bulk bind performance improvement, Assignment Help, Ask Question on Bulk fetching - bulk bind performance improvement, Get Answer, Expert's Help, Bulk fetching - bulk bind performance improvement Discussions

Write discussion on Bulk fetching - bulk bind performance improvement
Your posts are moderated
Related Questions
THEO R Y OF PANSPERMIA - Arrhenius (1908) postulated the cosmic panspermia theory that claims that organisms existed throughout the universe, and their spores, etc., could

Project Description: I want to write some SQL statements. The things I need are between pages 5-7. The only problem is that i want it till tomorrow. Skills required is SQL

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:

Iterative Control: LOOP  Statements The LOOP statement executes a series of statements multiple times. There are 3 forms of LOOP statements: LOOP, WHILE-LOOP, & FOR-LOOP. LOOP

Manipulating Collections Within PL/SQL, the collections add procedural power and flexibility. The biggest benefit is that your program can compute subscripts to process the spec

Scope and Visibility The References to an identifier are resolved according to its visibility and scope. The scope of an identifier is that area of a program unit (subprogram, b

%NOTFOUND The %NOTFOUND is the logical opposite of the %FOUND. The %NOTFOUND yields TRUE when an INSERT, UPDATE, or DELETE statement affected no rows, or the SELECT INTO state

Using TRIM This process has two forms. The TRIM removes an element from the end of the collection. The TRIM(n) removes the n elements from the end of the collection. For e.g.

SQL outer join SELECT * FROM IS_CALLED NATURAL LEFT JOIN IS_ENROLLED_ON Note that adding LEFT to an invocation of CROSS JOIN has no effect unless the right-hand operand

Need Database Development with Analysis Tools Project Description: I want a database for large governmental and private data sets on one country that can be simply extended t