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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Multi-dimensional Array

Re: Multi-dimensional Array

From: M <someone_at_microsoft.com>
Date: Tue, 18 Mar 2003 19:32:47 +0800
Message-ID: <b570ra$14ij$1@news.hgc.com.hk>


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

Original text of this message

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