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
Parameter and Keyword Description:   table_reference: This identifies a table or view which should be available when you execute the INSERT statement, and for that you sho

Closest Approximation to Relational Union - SQL Actually, just as SQL has several varieties of JOIN, it also has several varieties of UNION, none of which is equivalent to th

Data Types in SQL - Integer INTEGER or  synonymously INT, for integers within a certain range. SQL additionally has types SMALLINT and BIGINT for certain ranges of integers. T

Database Values You can use the SELECT statement to have the Oracle assign values to a variable. For Each and every item in the select list, there must be a matching, type-compa

Using Cursor Attributes To process the SQL data manipulation statements, the SQL engine must opens an implicit cursor named SQL. This cursor's attributes (%FOUND, %NOTFOUND, %

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

What Is a Collection The collection is an ordered group of elements, all of similar type (for e.g. the grades for a class of students). Each element has a unique subscript whic

Seeking a programmer to design a legal document with pre-existing fields that could allow the auto-population of client(s) information (i.e. Name, Account Number, Address etc.) int

Row Counterparts of Table Operators SQL does not have counterparts tuple rename, tuple projection, tuple extension, tuple join and tuple compose. To obtain the same effects as

Blocks: The fundamental program unit in the PL/SQL is the block. The PL/SQL block is defined by the keywords BEGIN, DECLARE, EXCEPTION, and END. These keywords partition the b