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

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL syntax, IS TABLE OF and .extend

Re: PL/SQL syntax, IS TABLE OF and .extend

From: Volker Apelt <gq437x_at_yahoo.de>
Date: 24 Oct 2002 13:49:30 +0200
Message-ID: <lgfzuwcb05.fsf@mu.biosolveit.local>


"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> writes:

> .EXTEND does not apply to INDEX-BY (aka PL/SQL) tables, only to nested tables
> (those without INDEX BY clause.) With PL/SQL tables, array elements are
> created automatically when you access them by index, no need for explicit
> extend.

I guess, that means there is no way/need to preallocate N elements.

Thank you,

Finn and Vladimir

-- 
Volker Apelt                   
Received on Thu Oct 24 2002 - 06:49:30 CDT

Original text of this message

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