Re: Multi-dimensional Array
Date: Tue, 18 Mar 2003 17:38:16 +0800
Message-ID: <b56q4i$10gg$1_at_news.hgc.com.hk>
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;
for a in 1 .. 100 loop
my_score(a) := a;
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.
begin
end loop;
end;
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 - 10:38:16 CET