Re: Sorting in Oracle7.3

Gregory Rapone wrote:
>
> I want to create a table that is in a sorted format based on the results of
> a sorted sub query. I know that the ORDER BY clause cannot appear in
> subqueries within other statements, but I want the valid equivalent to :
>
> CREATE TABLE not_sorted (FIELD1, FIELD2)
> AS
> SELECT FIELD1, FIELD2
> FROM sorted;
>

Greg,

To what purpose? It is my understanding that the order of rows returned from any query is undefined, unless you order them. So, it would seem to me that there would be nothing gained in creating a 'sorted' table.

Yours,  

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Thu Jun 11 1998 - 01:57:02 CDT