ARRAY in PL/SQL ???

From: Chow Hoi Ka, Eric <d951686_at_sftw.umac.mo>
Date: Wed, 23 Jun 1999 08:29:39 +0800
Message-ID: <37702A72.D862CF1E@sftw.umac.mo>

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

--

     _                                                  _
    / ) |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ( \
   / /  |                                            |  \ \
 _( /_  | _   Chow Hoi Ka, Eric                    _ |  _) )_


(((\ \> |/ )                                      ( \| </ /)))


(\\\\ \_/ /   E-Mail : d951686_at_sftw.umac.mo        \ \_/ ////)
 \       /                                          \        /
  \    _/     http://www.sftw.umac.mo/~d951686/      \_     /
  /   / |____________________________________________| \    \
 /   /                                                   \    \

Received on Tue Jun 22 1999 - 19:29:39 CDT