db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From alvaroCab <alvarocaba...@hotmail.com>
Subject Create a Nested Table or a dynamic table
Date Mon, 04 Jan 2010 09:27:07 GMT

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.

View raw message