Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Q: VARRAY vs. Nested tables?
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