Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Simplest way to create/use PLSQL collections

Re: Simplest way to create/use PLSQL collections

From: Ranko Mosic <ranko.mosic_at_gmail.com>
Date: Thu, 19 May 2005 21:19:08 -0400
Message-ID: <367369f1050519181944c08f94@mail.gmail.com>


Solved by:=20

- type x x_table%rowtype indexed by binary_integer;
- array x; =20
- bulk collect into array
- for i in 1..array.count loop=20
       array(i).array_member

  end loop;

Thanks all, Ranko.=20

On 5/19/05, Post, Ethan <Ethan.Post_at_ps.net> wrote:
> Bug 2874489 Excessive REDO generated for INSERT as SELECT into GLOBAL
> TEMPORARY TABLES
>=20
> Using 'insert as select' to insert into a global=3D20
> temporary table can generate far more redo than=3D20
> the same insert into a permanent table.
>=20
> Updates and deletes are not affected, only multirow inserts.
>=20
> Affects:
> Product (Component) Oracle Server (Rdbms)=3D20
> Range of versions believed to be affected Versions < 10.1.0.2 =3D20
> Versions confirmed as being affected 9.2.0.4=3D20
> =3D20
> Platforms affected Generic (all / most platforms affected)=3D20
>=20
> Fixed:
> This issue is fixed in 9.2.0.5 (Server Patch Set)=3D20
> 10.1.0.2=3D20
> =3D20
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 19 2005 - 21:23:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US