Re: CREATE ORDERED TABLE

From: Erwin Dondorp <erwindon_at_wxs.nl>
Date: Fri, 17 Dec 1999 00:09:05 +0100
Message-ID: <38597111.841EB6B3@wxs.nl>

Sheila Zou wrote:
> sorry,
>
> but this is what i got:
>
> Connected to:
> Oracle8 Enterprise Edition Release 8.0.5.2.0 - Production
> With the Partitioning, Objects and Parallel Server options
> PL/SQL Release 8.0.5.2.0 - Production
>
> SQL> create table test as
> 2 select * from accounts order by acc_id;
> select * from accounts order by acc_id
> *
> ERROR at line 2:
> ORA-00933: SQL command not properly ended
>
> > Sorry, but I did test it..

Oracle 8i supports "INSERT ... SELECT ... ORDER BY ..." Oracle 8 and lower do not support the ORDER BY clause in this case.

--
Erwin Dondorp
<http://www.dondorp.com/> Received on Thu Dec 16 1999 - 17:09:05 CST