CREATE ORDERED TABLE

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 - 15:02:25 CST