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
I need SQL , WP SQL Expert Project Description: Expert required to modify WP SQL query. Skills required are MySQL, SQL, PHP, Wordpress

Advantages of Subprograms The Subprograms give extensibility; that is, tailor the PL/SQL language to suit your requirements. For illustration, if you require a procedure which

Predicate - SQL Consider the declarative sentence-a proposition-that is used to introduce this topic:  "Student S1, named Anne, is enrolled on course C1." Recall that th

Implicit Cursor is declared and used by the oracle environment internally. while the explicit cursor is declared and used by the external user. more over implicitly cursors are no

MECHANISTI S THEORY-HAECKEL (1866) - Haeckel stating that after each catalysm, some new organism suddenly forms as a chance event in one stride from inanimate matter and sub

Pl/sql Conditional Control: IF statements Frequently, it is necessary to take the alternative actions depending on the circumstances. The IF statement execute a series of statem

Defining and Declaring Records To create records, you have to define a RECORD type, and then declare records of that type. You may also define RECORD types in the declarative

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

Avoid the NOT NULL Constraint In the PL/SQL, using the NOT NULL constraint incur a performance cost. Consider the illustration as shown below: PROCEDURE calc_m IS m NUMB

Parameter and Keyword Description: label_name: This is an undeclared identifier which optionally labels a loop. When used, the label_name should be enclosed by double ang