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]

"Jan Callewaert" <ja****************@Mhotmail.com> wrote in message
news:pa****************************@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.