Is it possible this nested table?
From: Adolfo Sánchez <adfsanchez_at_gmv.es>
Date: Mon, 20 Dec 1999 17:25:01 +0100
Message-ID: <385E585C.337CF6ED_at_gmv.es>
[Quoted] Hi all,
Date: Mon, 20 Dec 1999 17:25:01 +0100
Message-ID: <385E585C.337CF6ED_at_gmv.es>
[Quoted] Hi all,
[Quoted] Why there is an error in this sql file when I create the table parameter_values_table?
drop type parameter_type;
drop type value_table;
drop type value_type;
drop table opmode_table;
drop type opmode_type;
create type opmode_type as object(
name varchar(10));
/
create table opmode_table of opmode_type;
create type value_type as object(
value number,
opmode ref opmode_type);
/
create type value_table as table of value_type;
/
create type parameter_type as object(
name varchar(10));
/
create table parameter_values_table(
parameter parameter_type,
values value_table)
nested table values store as parameter_values;
-- ____________________________________________________________________ Adolfo Sánchez Domínguez GMV, S.A. Grupo de Mecánica de Vuelo mailto:adfsanchez_at_gmv.es Sector Foresta,1. TRES CANTOS PHO: +34 91 806 4443 E-28760 MADRID (SPAIN) FAX: +34 91 806 4641 http://www.gmv.esReceived on Mon Dec 20 1999 - 17:25:01 CET