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:19:24 CDT