order by in a view help please !

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 - 10:23:35 CDT