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:


TYPE NameTab IS TABLE OF emp.ename%TYPE;


names NameTab;

sals SalTab;

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


OPEN c1;




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
Definition of FROM - SQL Recall that the operand of FROM is denoted by a commalist, each element of that commalist being a table expression optionally accompanied by a range v

Exceptions An exception is the runtime error or warning condition that can be predefined or user-defined. The Predefined exceptions are raised implicitly through runtime system

MAX and MIN operator in SQL Example: (SELECT MAX (Mark) FROM EXAM_MARK WHERE StudentId = 'S1') (SELECT MIN (Mark) FROM EXAM_MARK WHERE StudentId = 'S1') Example

Example of EXCEPT Operator - SQL Example, like its counterpart in the theory book, illustrates the convenience of allowing any table expression to be the source for an INSERT

Write an anonymous block that contains a PL/SQL procedure. The procedure takes two input parameter: oldZip and newZip, and it updates the zipcodes table by replacing all oldZip wit

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 Cursors how to use it in Real time application ?

Short-Circuit Evaluation When computing a logical expression, the PL/SQL uses short-circuit evaluation. That is, the PL/SQL stops computing the expression as soon as the result

Using Operator DEREF: You cannot navigate through refs within the PL/SQL procedural statements. Rather than, you should use the operator DEREF in the SQL statement. The DEREF

LOOP Statements The LOOP statements execute a series of statements at multiple times. The loops enclose the series of statements that is to be repeated. The PL/SQL provides typ