Re: order by in a view help please !

You cann't use "order by" in a create view statement.

In the select statement of your view, place the order by there, as in..

• create the view... create view test as select name,address from customer
• select the data from the view... select * from test order by name

Jim

Mujahid Hamid wrote in message
<899738710.4082.0.nnrp-06.c2de4f17_at_news.demon.co.uk>...
>Dear all,
>I am trying to use order by in a view but I get Ora 00933 (sql not properly
>ended)
>When I use the following I get errors:
>for example
> 1.Create view test
> select name, address from customer
> order by name
>2. create table customer_1 as select * from customers
> order by name,
>3. insert into customer select * from old_customer
> order by name
>
>how can I create a sorted table from an unsorted table ?
>
>Thanks for you help
>Mujahid
>
>
>
Received on Mon Jul 06 1998 - 18:01:22 CDT