oracle and SQL3

[Jan Callewaert]

Hi,
i see everywhere in the specifications of oracle that it supports sql3.
But i can't find a way for inheriting tables:
CREATE TABLE TEST2( TEKST3 Varchar(15)) UNDER TEST or
CREATE TABLE TEST2( TEKST3 Varchar(15), UNDER TEST)

don't seem to work. I get the syntax from of the second from
http://docs.openlinksw.com/virtuoso/...BLE.html#under.

Am i using the wrong syntax, or is this not supported. I am using btw
Oracle8, but normally this version should support sql3.

Regards,

Jan

[Douglas Hawthorne]

Re: oracle and SQL3

"Jan Callewaert" <jan_callewaert NOSP@Mhotmail.c omwrote in message
news:pan.2004.0 4.23.09.39.49.9 03942@Mhotmail. com...

Hi,
i see everywhere in the specifications of oracle that it supports sql3.
But i can't find a way for inheriting tables:
CREATE TABLE TEST2( TEKST3 Varchar(15)) UNDER TEST or
CREATE TABLE TEST2( TEKST3 Varchar(15), UNDER TEST)
>
don't seem to work. I get the syntax from of the second from
http://docs.openlinksw.com/virtuoso/...BLE.html#under.
>
Am i using the wrong syntax, or is this not supported. I am using btw
Oracle8, but normally this version should support sql3.
>
Regards,
>
Jan

Jan,

The equivalent in Oracle is called Nested Table. Have a look at "Nested
Table" at
http://asktom.oracle.com/pls/ask/f?p...D:410619303624 ,
and at http://www.psoug.org/reference/nested_tab.html for some references on
Nested Tables.

Douglas Hawthorne.