Re: Create View and Order By?

From: Collin Leung <collinl_at_vtc.edu.hk>
Date: Mon, 3 Aug 1998 15:51:23 +0800
Message-ID: <6q3q8k$9dq@is1.vtc.edu.hk>

A view's query can be any SELECT statement without the ORDER BY or FOR UPDATE clauses.

Violin wrote in message <35c55d38.15955535_at_news.twsc.pouchen.com.tw>...
>Hello,
>Does anyone know if it work when you create view as
>select .....from ... where ....order by column_name?
>'Cause when I create view and order by column_name,
>an error occurs:ORA-00933: SQL command not properly ended.
>Without order by the view was created successfully.
>Couldn't view order by column_name?
>Please Cc to :violin.hsiao_at_mail.pouchen.com.tw,Thank you :)
Received on Mon Aug 03 1998 - 02:51:23 CDT