PL/SQL (MOSC)

MOSC Banner

How to process Large volume data with good performance

edited Jul 24, 2014 5:00AM in PL/SQL (MOSC) 3 commentsAnswered

Hi,

I have a cursor which returns around 800000 records/run. Below is the sample code i'm writing to process the cursor data

Declare

Cursor c1 is select column_1.....Column110

from <table_name >

where conditions1 = condition2.

type sample_tbl_typ is table of c1%rowtype index by simple_integer;

sample_tbl sample_tbl_typ;

type sample_tbl_typ1 is table of <table_rowtyp>%rowtype index by simple_integer; --this table is having near about 110 columns

sample_tbl1 sample_tbl_typ1;

begin

open c1;

fetch c1 bulk collect into sample_tbl;

close c1;

if sample_tbl.count > 0 then

     for i in sample_tbl.first..sample_tbl.last loop

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center