Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to create a second table as sorted on one column of first table?
David Shi wrote :
>I tried:
>
> create table second as select * from first order by key;
>
>but didn't work. Any help is greatly appreciated!
>
>David
All right. The data in any table is unsorted. You can use ORDER BY clause when fetching data from the table. But when you create one table from another this means nothing.
Maxim. maximka_kr_at_usa.net Received on Tue May 19 1998 - 09:42:57 CDT