Re: Simplest way to create/use PLSQL collections
- From: Ranko Mosic <ranko.mosic@xxxxxxxxx>
- To: Ethan.Post@xxxxxx
- Date: Thu, 19 May 2005 21:19:08 -0400
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@xxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
