Re: Create View and Order By?

From: <nasof_at_hotmail.com>
Date: Mon, 03 Aug 1998 15:54:31 GMT
Message-ID: <6q4mfm$983$1@nnrp1.dejanews.com>

You cant order by, but you can "group by" which will order the results...

See if this helps you...

-Frank

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 :)
>

-----== 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 - 10:54:31 CDT