Re: CREATE ORDERED TABLE

From: <sacq_at_usa.net>
Date: Fri, 17 Dec 1999 00:52:50 GMT
Message-ID: <83c1h1$oqd$1@nnrp1.deja.com>

John Greco wrote:

> Sorry, but I did test it..
> [results omitted]
> So, I did get the results I posted....why it failed when you \
> tried I don't know

John is quite correct: this does work as mentioned. However, it /should not/ work, according to the Oracle documentation -- this may be causing the confusion.

The reason it should not work is that the syntax diagram for the "create table" command allows for a clause " ... AS subquery ...". A subquery cannot include an "ORDER BY" clause. Ergo, it should not be possible to do "create table ... as select ... order by".

It seems that the documentation should actually state that the "CREATE TABLE" command can include the clause "...AS select-statement" or something similar, since that's actually what Oracle allows.

Regards,

-bn

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 16 1999 - 18:52:50 CST