Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Multi-dimensional Array
May I know in detail how to do it in Oracle8i? I have tried the followings
but it doesn't work.
I even got compilation errors. Pls help to quote some examples. Thanks.
declare
type a is table of number(3) index by binary_integer;
type b is table of a index by binary_integer;
begin
null;
end;
"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
news:4pvd7v0euugv42fl7dae0b9cscieea7pt0_at_4ax.com...
> On Tue, 18 Mar 2003 17:38:16 +0800, "M" <someone_at_microsoft.com> wrote:
>
> >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.
>
>
> Just define your initial array as a type and setup a different type as
> a table of <initial type>
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Tue Mar 18 2003 - 05:32:47 CST
![]() |
![]() |