Re: CREATE ORDERED TABLE

Eliminate the parens... just use

create table junk as select * from other_table order by field_in_other_table;

It should work...
You cannot, as in your example, create a table by selecting from a table with the same name .....I assume a typo....

"Russell Sturm" <polaristech_at_earthlink.net> wrote:

>How do you create a new table based upon the ordered results of another
>table? In other words I was trying this --
>
>create table junk as (select * from junk order by field);
>
>but Oracle will not accept the order clause.
>
>Any help would be greatly appreciated.
>
>Thanks!
>
>Russ
>info_at_visualsoft.net
>
>

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Thu Dec 16 1999 - 15:59:18 CST