Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CREATE ORDERED TABLE
please make sure before you answer the question. it doesnot work I think.
TurkBear <johng_at_mm.com> wrote in message
news:38596030.26545460_at_super.news-ituk.to...
>
> 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 - 16:10:11 CST