Re: CREATE ORDERED TABLE

Create as select Order by ...

    Is a feature of 8.1, but has been back-ported     (possibly by accident) into 7.3.4.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

sacq_at_usa.net wrote in message <83c1h1$oqd$1_at_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 Fri Dec 17 1999 - 00:55:17 CST