Re: How to create a second table as sorted on one column of first table?

From: <stevec_at_zimmer.csufresno.edu>
Date: Mon, 18 May 1998 16:03:45 GMT
Message-ID: <6jpm51$f25$1@nnrp1.dejanews.com>

Oracle database tables are not sequential. You CANNOT create a table of records in a specific sequence. Rows are inserted into a table almost sequentially, but when a block fills up, records get put wherever the server feels like, and you cannot control it.

Always use the Order By clause, and you will always see the new table in whatever sequence you specify.

Steve Cosner
http://members.aol.com/stevec5088

In article <6jipt0$m7a$0_at_204.179.92.109>, dshi_at_magpage.com (David Shi) wrote:
>
> I tried:
>
> create table second as select * from first order by key;
>
> but didn't work. Any help is greatly appreciated!
>
> David
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon May 18 1998 - 11:03:45 CDT