Re: order by in a view help please !

From: John M. Reed Jr. <jmrjr_at_earthlink.net>
Date: Mon, 6 Jul 1998 19:04:53 +0100
Message-ID: <6nrsb4$5gb$1@birch.prod.itd.earthlink.net>

FYI, May not have an order by in an INSERT DML.

John

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 - 13:04:53 CDT