By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,501 Members | 1,859 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,501 IT Pros & Developers. It's quick & easy.

oracle and SQL3

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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.
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.