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! -- View this message in context: http://old.nabble.com/Create-a-Nested-Table-or-a-dynamic-table-tp27010524p27010524.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
