Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ARRAY in PL/SQL ???
A copy of this was sent to "Chow Hoi Ka, Eric" <d951686_at_sftw.umac.mo>
(if that email address didn't require changing)
On Wed, 23 Jun 1999 08:29:39 +0800, you wrote:
>Hello,
>
>Is it possible to define an ARRAY that can store differnt data type of
>data.
>
>Such as,
>
>declare
>TYPE myArray IS TABLE of some_description INDEX BY BINARY_INTEGER;
>array myArray;
>begin
> array(1) := 'Hello PL/SQL';
> array(2) := 123;
> array(3) := 456.789;
>end;
>
>Is it possible to implemment this ????
>
>
>Best regards,
>Eric
No, there are no heterogenous collections in pl/sql as yet. you would have to use an array of varchar2 and store all of the data in strings.
--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries Reston, VA USA
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jun 24 1999 - 06:17:21 CDT