Re: Multi-dimensional Array

pl/sql table is only single-dimension. for example,

declare

   type score_type is table of number(3) index by binary_integer;    my_score score_type;
begin

   for a in 1 .. 100 loop

      my_score(a) := a;
   end loop;
end;

Then I can assign values to my_score(a), a single-dimension array. Just want to know if there is something like, e.g. 2-dimensional arrays like my_score(a, b) ... or even multi-dimensional.

M.

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.com> wrote in message news:U1lda.141918$S_4.82850_at_rwcrnsc53...
> How about using pl/sql tables?
> Jim
> "M" <someone_at_microsoft.com> wrote in message
> news:b53ej3$2144$1_at_news.hgc.com.hk...
> > Hi all,
> >
> > Just want to know in Oracle 8i, can I define some multi-dimensional
array
> to
> > store data for analysis purpose. Can this kind of array be define on
the
> > fly, instead of some objects in the database?
> >
> > Thx.
> > M.
> >
> >
>
>
>
Received on Tue Mar 18 2003 - 03:38:16 CST