Re: PL/SQL Cursor Performance

Just to avoid confusion - it might be worth remembering that there is an array fetch feature in dbms_sql in Oracle 8.0, but not one that you could use for a cursor loop.

BTW: there is an article on my website on array fetches in PL/SQL version 8.0 which shows how to do exactly this sort of thing (read one table, copy to another) with
dbms_sql and array fetches.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Thomas Kyte wrote in message <37518714.4245394_at_newshost.us.oracle.com>...

>>for crs in
>>(select a, b, c
>>from x_table )
>>loop
>> insert into y_table(a, b, c)
>> values
>> (crs.a, crs.b, crs.c);
>>
>>end loop;
>>
>>Questions:
>>1. Does the cursor get all the rows in one go from the database?
>>OR
>
>No (although in Oracle8i, release 8.1 there is an array fetch that would
allow
>you to get all of the rows. In 8.0 and before -- no such option)
Received on Fri May 28 1999 - 10:38:52 CDT