Re: Create View and Order By?

From: <iolo_at_my-dejanews.com>
Date: Mon, 03 Aug 1998 10:26:31 GMT
Message-ID: <6q438m$j1a$1@nnrp1.dejanews.com>

In article <35c55d38.15955535_at_news.twsc.pouchen.com.tw>, violin.hsiao_at_mail.pouchen.com.tw (Violin) wrote:
> 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 :)
>

No - you can't do a create view where the select from contains an order by

Regards

--
Oliver Willandsen - European Commission http://europa.eu.int
All remarks are my own and do not necessarily reflect official European Commission policy

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Aug 03 1998 - 05:26:31 CDT