Re: Is it possible this nested table?
Date: Mon, 20 Dec 1999 18:31:41 +0100
Message-ID: <83lp69$8ie$1_at_news3.isdnet.net>
It is possible but "values" is a reserved word:
v815> create type opmode_type as object(
2 name varchar(10));
3 /
Type created.
v815> create table opmode_table of opmode_type;
Table created.
v815> create type value_type as object(
2 value number,
3 opmode ref opmode_type);
4 /
Type created.
v815> create type value_table as table of value_type; 2 /
Type created.
v815> create type parameter_type as object(
2 name varchar(10));
3 /
Type created.
v815> create table parameter_values_table(
2 parameter parameter_type,
3 values value_table)
4 nested table values store as parameter_values;
values value_table)
*
ERROR at line 3:
ORA-00904: invalid column name
If you enclose values with double-quotes that's work:
v815> create table parameter_values_table(
2 parameter parameter_type,
3 "values" value_table)
4 nested table "values" store as parameter_values;
Table created.
You can check the reserved words with the following view:
v815> select keyword from v$reserved_words where keyword='VALUES';
KEYWORD
VALUES 1 row selected.
-- Have a nice day Michel Adolfo Sánchez <adfsanchez_at_gmv.es> a écrit dans le message : 385E585C.337CF6ED_at_gmv.es...Received on Mon Dec 20 1999 - 18:31:41 CET
> Hi all,
>
> 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.es
>
>