Re: Multi-dimensional Array
Date: Tue, 18 Mar 2003 17:38:16 +0800
Message-ID: <b56q4i$10gg$1_at_news.hgc.com.hk>
[Quoted] [Quoted] pl/sql table is only single-dimension. for example,
declare
[Quoted] 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
[Quoted] 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 - 10:38:16 CET