Re: Sorting in Oracle7.3

From: Andrey Roslyakov <andrey-roslyakov_at_worldnet.att.net>
Date: Wed, 10 Jun 1998 22:56:50 -0400
Message-ID: <6lnh1d$cp1@bgtnsc03.worldnet.att.net>

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;
>
> many thanks,
> Greg.

What about view.
Andrey. Received on Wed Jun 10 1998 - 21:56:50 CDT