Re: CREATE ORDERED TABLE

Why would you want to do this? The first row you insert into this table later will put it out of order anyway. If you're thinking that it will speed access time - you might be right if you need to do a full table scan on the one column .... but then again, why not create an index?

• Troy

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 Thu Dec 16 1999 - 22:05:05 CST