Re: Oracle8 Object Tables and Nested Tables

hi,

I tested a lot of the oracle 8 features. As far as I now nested tables are just single level features as you suggested. It think I read in the Oracle 8 online documentation.

Keep in mind that you have to specify a name for a table where oracle stores the nested tables data.
I also encountered significantly bad performance while trying to select for something which is located in a nested table.

In your example:
What is the name of the person who has phone code 12312.

Be also aware of the fact that when you create tables from types you are stuck with the types, you won't be able to change.

Axel

--

• Dipl.-Ing. Axel Nagel *
• Max-Planck-Institut fuer Molekulare Genetik *
• Abteilung Lehrach *
• Ihnestrasse 73 *
• D-14195 Berlin *
• *
• Tel.: +49 (0)30 8413-1353 *
• email: nagel_at_mpimg-berlin-dahlem.mpg.de *

  ---