Re: Q: VARRAY vs. Nested tables?

From: gox <gox_at_tcp.co.uk>
Date: Thu, 14 Oct 1999 00:33:16 +0100
Message-ID: <axUFODiviUjRgk7zs+ddlk0TX=Yb@4ax.com>

On Wed, 13 Oct 1999 19:40:01 GMT, jlbenc_at_my-deja.com wrote:

>Hello,
>
>I would like to know which method is more reliable to use in storing
>complex data related to a record in Oracle 8i: VARRAY or Nested tables?
>
>Somebody told me that there are some data-loss issues when
>exporting/importing tables. Is this true?
>
>Thanks!!
>
>JLB - [para goriberto]

I always use Nested Tables. You have to be aware with the fact they are sparse dynamic lists, deleted items are not packed, so you have to loop through checking for nulls entities. But VARRAYs are static so less flexible.

Gox Received on Wed Oct 13 1999 - 18:33:16 CDT