Re: Create a Nested Table or a dynamic table

[Sylvain Leroux]

Hi Alvaro,

Depending of your needs, using two tables and a foreign key could suffice? 
Something like that:

create table bag_with_items (
   bag_id                   number(7)     primary key,
   bag_name                 varchar2(30)  not null,
   ...
)

create table Item (
   bag_id                   number(7) REFERENCES bag_with_items(bag_id),

   item_id Number  ( 6  ),
   descr   varchar2(30  ),
   quant   Number  ( 4,2)
)

But maybe I missed something important?

Sylvain.

alvaroCab a écrit :

Is there a way to create something similar to this in Apache Derby?

create or replace type item as object (
  item_id Number  ( 6  ),
  descr   varchar2(30  ),
  quant   Number  ( 4,2)
);

create or replace type items as table of item;

create table bag_with_items (
  bag_id                   number(7)     primary key,
  bag_name                 varchar2(30)  not null,
  the_items_in_the_bag     items         
)
nested table the_items_in_the_bag store as bag_items_nt;

If not.. is it possible to create a List row or something like this where I
could put the keys of another tables?

Thanks to all!




--
sylv...@chicoree.fr
http://www.chicoree.fr