Re: CREATE ORDERED TABLE

From: Serguei Siassine <serg_at_canadamail.com>
Date: Fri, 17 Dec 1999 15:08:09 -0500
Message-ID: <385A9829.A5551261@canadamail.com>

Try this

create or replace view COMPANY_VIEW as
select Company_ID,

            field2,
            field3,
            ......
            fieldN

from COMPANY
group by Company_ID,

            field2,
            field3,
            ......
            fieldN,
            RowNum;

create table COMPANY_ORDERED
as select * from COMPANY_VIEW;

If you have duplicate rows, RowNum will help.

Sergeui Siassine
serg_at_canadamail.com

Russell Sturm 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
Received on Fri Dec 17 1999 - 14:08:09 CST